How to identify the SQL_ID of a statement in Oracle Apps R12
1) Run the below SQL Query.
SELECT /* ORACLE SQL */ * FROM dual;
2) Run below query to get above ran SQL ID.
SELECT sql_id, plan_hash_value, substr(sql_text,1,40) sql_text
FROM v$sql
WHERE sql_text like 'SELECT /* ORACLE SQL */%'
------Here is the Output---------------
SQL_ID SQL_TEXT
------------- ----------------------------------------
0xzpkrs5gktjs SELECT /* ORACLE SQL */ * FROM dual
No comments:
Post a Comment