Oracle Object being Access

Oracle Object being access
identify objects being accessed by sessions.
object access
Oracle access


set feed off
set pagesize 10000
set wrap off
set linesize 200;
set heading on
set tab on
set scan on
set verify off
col "Object Being Accessed" format a25
col "sid-serial" format a15
col "User" format a12
col "Owner" like "User"
col sql_text format a40
--
ttitle left 'Who uses what objects' -
skip 2

select a.sid||','||serial# "sid-serial",substr(s.username,1,10) "User",substr(a.owner,1,10) "Owner",
substr(a.object,1,30) "Object Being Accessed",s.sql_id,substr(sql_text,1,40) sql_text
from V$ACCESS a, V$SESSION s ,v$sql sq
where a.sid = s.sid
and a.owner !='SYS'
and sq.sql_id (+) = s.sql_id;




sid-serial User Owner Object Being Accessed SQL_ID SQL_TEXT
--------------- ------------ ------------ ------------------------- ------------- ----------------------------------------
13,1 PUBLIC DBA_INDEXES
41,9032 SYS PUBLIC V$PARAMETER 2h6wst2nza2wv select a.sid||','||serial# "sid-serial",
41,9032 SYS GGATE GGS_SETUP 2h6wst2nza2wv select a.sid||','||serial# "sid-serial",
13,1 PUBLIC DBA_TAB_PARTITIONS
13,1 GGATE GGS_TEMP_COLS
13,1 PUBLIC DBMS_UTILITY
13,1 PUBLIC DBMS_SESSION
13,1 GGATE GGS_SETUP
41,9032 SYS PUBLIC DBA_IND_COLUMNS 2h6wst2nza2wv select a.sid||','||serial# "sid-serial",
41,9032 SYS CTXSYS DRIERR 2h6wst2nza2wv select a.sid||','||serial# "sid-serial",
41,9032 SYS CTXSYS DR$OBJECT_ATTRIBUTE 2h6wst2nza2wv select a.sid||','||serial# "sid-serial",