Oracle Fusion Data Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Can an Oracle ERP Fusion account get access to selected gv$ views

Received Response
4
Views
1
Comments

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