One stop Oracle Database Knowledge center for DBAs
Future of ORACLE DBA
Saturday, September 24, 2016
Script to find active sql for specific users
SELECT a.username, b.sql_text,a.status from v$session a INNER JOIN v$sqlarea b ON a.sql_id = b.sql_id where a.username in ('USERNAME') and a.status='ACTIVE';
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment