Home » RDBMS Server » Server Administration » Active Table at Current DB Session (Oracle 10g, Sun Solaris 10)
Active Table at Current DB Session [message #393946] Wed, 25 March 2009 02:50 Go to next message
suiren97
Messages: 48
Registered: May 2007
Location: Malaysia
Member
How to check current active/being accessed objects in DB session?

Thanks.
Re: Active Table at Current DB Session [message #393973 is a reply to message #393946] Wed, 25 March 2009 04:31 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

SELECT spid, osuser, s.program FROM v$process p, v$session s WHERE p.addr=s.paddr and s.sid in (&n);

select sql_text from v$sqltext
where address = (select sql_address from v$session where paddr = (select addr from v$process where spid = &n))
order by piece;


Use the above query to find active session information.

>>Active Table at Current DB Session

NO

Babu

[Updated on: Wed, 25 March 2009 04:32]

Report message to a moderator

Re: Active Table at Current DB Session [message #393990 is a reply to message #393946] Wed, 25 March 2009 05:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
v$accesss

Regards
Michel
Re: Active Table at Current DB Session [message #394152 is a reply to message #393990] Wed, 25 March 2009 19:51 Go to previous message
suiren97
Messages: 48
Registered: May 2007
Location: Malaysia
Member
Thanks for the fast response.
This is what I'm looking for - v$access.

Thank you. Smile
Previous Topic: root.sh
Next Topic: Changing a subpartition initial extent
Goto Forum:
  


Current Time: Sat Dec 03 00:49:01 CST 2016

Total time taken to generate the page: 0.15621 seconds