Oracle Fusion AI Data Platform

We are moving this forum's discussions to a new location. During this transition, this forum will become read-only starting 15th January 2026. For any new questions, please email us at analytics-community-ww_mb@oracle.com. Thank you for your understanding and continued participation!
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
1
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