ORACLE APPS DBA FAQS
This blog is designed to capture/compile all important,useful and real time questions,scenarios really required for a Oracle DBA and Oracle Apps DBA. Please do comment your comments and suggestions.
Wednesday, June 13, 2012
which sql is running on background
SELECT a.username, b.sql_text FROM v$session a, v$sqlarea b, v$process c
WHERE c.spid = '&PID' AND a.paddr = c.addr AND a.sql_address = b.address;
No comments:
Post a Comment