Search This Blog

2009-09-22

Oracle current activity

Uses following query to find out what SID is accessing HR table:

select sid from v$access where OBJECT='HR'

No comments: