Categories
- All Categories
- 7 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 204 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.6K Oracle Analytics Forums
- 6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 72 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Can an Oracle ERP Fusion account get access to selected gv$ views
There lacks transparency with how the database is performing and maintained. This requires read only access to selected gv$ views to assist in troubleshooting performance issues on backend processes. Currently in Oracle Fusion ERP 25A there are only a few helpful views to look at locking and blocking sessions, and one to view long op sessions, and none to view badly constructed SQL. We need read only access to V$SQL, V$SQLAREA, V$SQLTEXT, V$EVENT_NAME, V$LOCKED_OBJECT, and other dynamic views to affectively support our clients.
Answers
-
Hi Robert,
Welcome to Oracle Analytics community.
Unfortunately, access to these views is not available on Fusion SaaS. We normally work with Oracle support for BIP report performance related issues to give us the details.
Thanks.
0
