Total Pageviews

Sunday, 10 September 2023

EBS : How to identify the SQL_ID of a statement in Oracle Apps R12


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

FUSION : BIP Reports Multiple Parameter Selection

How to make parameter multiple value selection in FUSION BIP REPORT    AND ( least(:P_PR_NUMBER) is null   or   prha.requisition_header_id i...