How to Check SQL Running in Oracle Database? DBA scripts to check SQL Running in Oracle Database?
Ezana Answered question 20/04/2023
DBA scripts to query SQL running in Oracle Database:
1 2 3 4 5 6 7 8 9 | select sid, s.SQL_ID, s.sql_text, v.username, v.status, v.action from v$session v, v$sqlarea s where v.sql_address = s.address and v.sql_hash_value = s.hash_value AND V.STATUS='ACTIVE' / |
Ezana Answered question 20/04/2023