Displaying SQL Profile Information In Oracle

You have created and accepted several SQL profiles and now want to view information related to these database objects.

Use the DBA_SQL_PROFILES view to display information about SQL profiles. Here’s an example that selects the most interesting columns:

SQL> select name, type, status, sql_text from dba_sql_profiles;

Here is a snippet of the output:

NAME TYPE STATUS SQL_TEXT
------------------------------ ------- -------- ------------------------------
SYS_SQLPROF_012eda58a1be0001 MANUAL ENABLED SELECT ecm_snapshot_id AS id...
SYS_SQLPROF_012ea20305980000 MANUAL ENABLED SELECT * FROM inv_maint...
SYS_SQLPROF_012edf0316930003 MANUAL ENABLED SELECT /* + parallel(mgmt_db_f...