select
  AUDIT_TYPE,                              -- AUDIT_TYPE NUMBER
  SESSION_ID,                              -- SESSION_ID NUMBER
  PROXY_SESSIONID,                         -- PROXY_SESSIONID NUMBER
  STATEMENTID,                             -- STATEMENTID NUMBER
  ENTRYID,                                 -- ENTRYID NUMBER
  EXTENDED_TIMESTAMP,                      -- EXTENDED_TIMESTAMP TIMESTAMP(6) WITH TIME ZONE
  GLOBAL_UID,                              -- GLOBAL_UID VARCHAR2(32)
  DB_USER,                                 -- DB_USER VARCHAR2(30)
  CLIENTIDENTIFIER,                        -- CLIENTIDENTIFIER VARCHAR2(64)
  EXT_NAME,                                -- EXT_NAME VARCHAR2(1024)
  OS_USER,                                 -- OS_USER VARCHAR2(30)
  OS_HOST,                                 -- OS_HOST VARCHAR2(128)
  OS_PROCESS,                              -- OS_PROCESS VARCHAR2(16)
  TERMINAL,                                -- TERMINAL VARCHAR2(16)
  INSTANCE_NUMBER,                         -- INSTANCE_NUMBER NUMBER
  OBJECT_SCHEMA,                           -- OBJECT_SCHEMA VARCHAR2(30)
  OBJECT_NAME,                             -- OBJECT_NAME VARCHAR2(30)
  POLICY_NAME,                             -- POLICY_NAME VARCHAR2(30)
  NEW_OWNER,                               -- NEW_OWNER VARCHAR2(30)
  NEW_NAME,                                -- NEW_NAME VARCHAR2(30)
  ACTION,                                  -- ACTION NUMBER
  STATEMENT_TYPE,                          -- STATEMENT_TYPE NUMBER
  TRANSACTIONID,                           -- TRANSACTIONID RAW(8)
  RETURNCODE,                              -- RETURNCODE NUMBER
  SCN,                                     -- SCN NUMBER
  COMMENT_TEXT,                            -- COMMENT_TEXT VARCHAR2(4000)
  AUTH_PRIVILEGES,                         -- AUTH_PRIVILEGES VARCHAR2(16)
  GRANTEE,                                 -- GRANTEE VARCHAR2(30)
  PRIV_USED,                               -- PRIV_USED NUMBER
  SES_ACTIONS,                             -- SES_ACTIONS VARCHAR2(16)
  OS_PRIVILEGE,                            -- OS_PRIVILEGE VARCHAR2(7)
  ECONTEXT_ID,                             -- ECONTEXT_ID VARCHAR2(64)
  SQL_BIND,                                -- SQL_BIND VARCHAR2(4000)
  SQL_TEXT,                                -- SQL_TEXT VARCHAR2(4000)
  OBJ_EDITION_NAME,                        -- OBJ_EDITION_NAME VARCHAR2(30)
  DBID                                     -- DBID NUMBER
from
  GV$XML_AUDIT_TRAIL
where
  inst_id=USERENV('Instance')