Home » RDBMS Server » Performance Tuning » Want sql executed session wise
Want sql executed session wise [message #110781] Thu, 10 March 2005 05:29 Go to next message
Messages: 8
Registered: February 2005
Location: Ahmedabad
Junior Member
Hello friends,

I want a sql for sql_text executed per session wise.

Re: Want sql executed session wise [message #110927 is a reply to message #110781] Fri, 11 March 2005 03:08 Go to previous message
Frank Naude
Messages: 4578
Registered: April 1998
Senior Member
Try something like this:

select sid,
       s.username, s.terminal, s.process, s.osuser,
from   sys.v_$session s, sys.v_$sqlarea a
where  s.type           = 'USER'
and    s.sql_address    = a.address
and    s.sql_hash_value = a.hash_value

Best regards.

Previous Topic: High Consistent gets
Next Topic: Undo Tablespace Issue - Archiving Case
Goto Forum:

Current Time: Tue Feb 27 06:24:03 CST 2024