V$ACCESS definition in Oracle Database 11.2

V$ACCESS

select
  SID,                                     -- SID NUMBER
  OWNER,                                   -- OWNER VARCHAR2(64)
  OBJECT,                                  -- OBJECT VARCHAR2(1000)
  TYPE                                     -- TYPE VARCHAR2(64)
from
  GV$ACCESS
where
  inst_id = USERENV('Instance')

home | up