Script – List Objects being accessed by a particular SID
- Posted by Gavin Soorma
- On July 1, 2009
- 0 Comments
set pagesize 300 select sid,serial#,username,status from v$session WHERE USERNAME IS NOT NULL order by STATUS DESC; col sid format 999 col owner format a10 col object format a20 col type format a10 set linesize 300 /* ENTER THE SID TO CHECK */ select sid,owner,object,type from v$access where sid = &sid order by owner,type ;
Read More