active sql

imlihj2007發表於2010-06-03
SQL

select

'USERNAME'
AND sid in (SELECT SID FROM V$SESSION WHERE STATUS = 'ACTIVE')

select *
from v$access
where owner = 'username'
and sid in (SELECT SID FROM V$SESSION WHERE STATUS = 'ACTIVE')
and type in ('TABLE','PACKAGE')
 *
from dba_ddl_locks
where owner =[@more@]

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/9879835/viewspace-1034153/，如需轉載，請註明出處，否則將追究法律責任。

相關文章