dba_sql_profile
dba_sql_profiles shows sql_text for the sql statement used to create the profile. I want to know the hash_value or sql_id for this sql statement. How do I find that?
I know in v$sql, there is a column sql_profile and from v$sql one can get sql_id, has-value. However, v$sql only shows sql’s which are currently in SGA’s. There should be some other way to get this information for all the sql statements.
Prem