eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.V_$UNIFIED_AUDIT_TRAIL

Object Details

Object Name:	V_$UNIFIED_AUDIT_TRAIL
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
AUDIT_TYPE	NUMBER
SESSIONID	NUMBER
PROXY_SESSIONID	NUMBER
OS_USER	VARCHAR2	(30)
HOST_NAME	VARCHAR2	(128)
TERMINAL	VARCHAR2	(30)
INSTANCE_ID	NUMBER
DBID	NUMBER
AUTHENTICATION_TYPE	VARCHAR2	(1024)
USERID	VARCHAR2	(30)
PROXY_USERID	VARCHAR2	(30)
EXTERNAL_USERID	VARCHAR2	(1024)
GLOBAL_USERID	VARCHAR2	(32)
CLIENT_PROGRAM_NAME	VARCHAR2	(48)
DBLINK_INFO	VARCHAR2	(4000)
XS_USER_NAME	VARCHAR2	(128)
XS_SESSIONID	RAW	(33)
ENTRY_ID	NUMBER
STATEMENT_ID	NUMBER
EVENT_TIMESTAMP	TIMESTAMP(6) WITH TIME ZONE	(20)
ACTION	NUMBER
RETURN_CODE	NUMBER
OS_PROCESS	VARCHAR2	(16)
TRANSACTION_ID	RAW	(8)
SCN	NUMBER
EXECUTION_ID	VARCHAR2	(64)
OBJ_OWNER	VARCHAR2	(30)
OBJ_NAME	VARCHAR2	(128)
SQL_TEXT	CLOB	(4000)
SQL_BINDS	CLOB	(4000)
APPLICATION_CONTEXTS	VARCHAR2	(4000)
CLIENT_IDENTIFIER	VARCHAR2	(64)
NEW_OWNER	VARCHAR2	(30)
NEW_NAME	VARCHAR2	(128)
OBJECT_EDITION	VARCHAR2	(30)
SYSTEM_PRIVILEGE_USED	VARCHAR2	(1024)
SYSTEM_PRIVILEGE	NUMBER
AUDIT_OPTION	NUMBER
OBJECT_PRIVILEGES	VARCHAR2	(19)
ROLE	VARCHAR2	(30)
TARGET_USER	VARCHAR2	(30)
EXCLUDED_USER	VARCHAR2	(30)
EXCLUDED_SCHEMA	VARCHAR2	(30)
EXCLUDED_OBJECT	VARCHAR2	(128)
ADDITIONAL_INFO	VARCHAR2	(4000)
UNIFIED_AUDIT_POLICIES	VARCHAR2	(4000)
FGA_POLICY_NAME	VARCHAR2	(30)
XS_INACTIVITY_TIMEOUT	NUMBER
XS_ENTITY_TYPE	VARCHAR2	(32)
XS_TARGET_PRINCIPAL_NAME	VARCHAR2	(30)
XS_PROXY_USER_NAME	VARCHAR2	(30)
XS_DATASEC_POLICY_NAME	VARCHAR2	(30)
XS_SCHEMA_NAME	VARCHAR2	(30)
XS_CALLBACK_EVENT_TYPE	VARCHAR2	(32)
XS_PACKAGE_NAME	VARCHAR2	(30)
XS_PROCEDURE_NAME	VARCHAR2	(30)
XS_ENABLED_ROLE	VARCHAR2	(30)
XS_COOKIE	VARCHAR2	(1024)
XS_NS_NAME	VARCHAR2	(30)
XS_NS_ATTRIBUTE	VARCHAR2	(4000)
XS_NS_ATTRIBUTE_OLD_VAL	VARCHAR2	(4000)
XS_NS_ATTRIBUTE_NEW_VAL	VARCHAR2	(4000)
DV_ACTION_CODE	NUMBER
DV_ACTION_NAME	VARCHAR2	(30)
DV_EXTENDED_ACTION_CODE	NUMBER
DV_GRANTEE	VARCHAR2	(30)
DV_RETURN_CODE	NUMBER
DV_ACTION_OBJECT_NAME	VARCHAR2	(128)
DV_RULE_SET_NAME	VARCHAR2	(90)
DV_COMMENT	VARCHAR2	(4000)
DV_FACTOR_CONTEXT	VARCHAR2	(4000)
DV_OBJECT_STATUS	VARCHAR2	(1)
OLS_POLICY_NAME	VARCHAR2	(30)
OLS_GRANTEE	VARCHAR2	(30)
OLS_MAX_READ_LABEL	VARCHAR2	(4000)
OLS_MAX_WRITE_LABEL	VARCHAR2	(4000)
OLS_MIN_WRITE_LABEL	VARCHAR2	(4000)
OLS_PRIVILEGES_GRANTED	VARCHAR2	(30)
OLS_PROGRAM_UNIT_NAME	VARCHAR2	(30)
OLS_PRIVILEGES_USED	VARCHAR2	(128)
OLS_STRING_LABEL	VARCHAR2	(4000)
OLS_LABEL_COMPONENT_TYPE	VARCHAR2	(12)
OLS_LABEL_COMPONENT_NAME	VARCHAR2	(30)
OLS_PARENT_GROUP_NAME	VARCHAR2	(30)
OLS_OLD_VALUE	VARCHAR2	(4000)
OLS_NEW_VALUE	VARCHAR2	(4000)
RMAN_SESSION_RECID	NUMBER
RMAN_SESSION_STAMP	NUMBER
RMAN_OPERATION	VARCHAR2	(20)
RMAN_OBJECT_TYPE	VARCHAR2	(20)
RMAN_DEVICE_TYPE	VARCHAR2	(5)
DP_TEXT_PARAMETERS1	VARCHAR2	(512)
DP_BOOLEAN_PARAMETERS1	VARCHAR2	(512)
DIRECT_PATH_NUM_COLUMNS_LOADED	NUMBER
CON_ID	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT AUDIT_TYPE
,      SESSIONID
,      PROXY_SESSIONID
,      OS_USER
,      HOST_NAME
,      TERMINAL
,      INSTANCE_ID
,      DBID
,      AUTHENTICATION_TYPE
,      USERID
,      PROXY_USERID
,      EXTERNAL_USERID
,      GLOBAL_USERID
,      CLIENT_PROGRAM_NAME
,      DBLINK_INFO
,      XS_USER_NAME
,      XS_SESSIONID
,      ENTRY_ID
,      STATEMENT_ID
,      EVENT_TIMESTAMP
,      ACTION
,      RETURN_CODE
,      OS_PROCESS
,      TRANSACTION_ID
,      SCN
,      EXECUTION_ID
,      OBJ_OWNER
,      OBJ_NAME
,      SQL_TEXT
,      SQL_BINDS
,      APPLICATION_CONTEXTS
,      CLIENT_IDENTIFIER
,      NEW_OWNER
,      NEW_NAME
,      OBJECT_EDITION
,      SYSTEM_PRIVILEGE_USED
,      SYSTEM_PRIVILEGE
,      AUDIT_OPTION
,      OBJECT_PRIVILEGES
,      ROLE
,      TARGET_USER
,      EXCLUDED_USER
,      EXCLUDED_SCHEMA
,      EXCLUDED_OBJECT
,      ADDITIONAL_INFO
,      UNIFIED_AUDIT_POLICIES
,      FGA_POLICY_NAME
,      XS_INACTIVITY_TIMEOUT
,      XS_ENTITY_TYPE
,      XS_TARGET_PRINCIPAL_NAME
,      XS_PROXY_USER_NAME
,      XS_DATASEC_POLICY_NAME
,      XS_SCHEMA_NAME
,      XS_CALLBACK_EVENT_TYPE
,      XS_PACKAGE_NAME
,      XS_PROCEDURE_NAME
,      XS_ENABLED_ROLE
,      XS_COOKIE
,      XS_NS_NAME
,      XS_NS_ATTRIBUTE
,      XS_NS_ATTRIBUTE_OLD_VAL
,      XS_NS_ATTRIBUTE_NEW_VAL
,      DV_ACTION_CODE
,      DV_ACTION_NAME
,      DV_EXTENDED_ACTION_CODE
,      DV_GRANTEE
,      DV_RETURN_CODE
,      DV_ACTION_OBJECT_NAME
,      DV_RULE_SET_NAME
,      DV_COMMENT
,      DV_FACTOR_CONTEXT
,      DV_OBJECT_STATUS
,      OLS_POLICY_NAME
,      OLS_GRANTEE
,      OLS_MAX_READ_LABEL
,      OLS_MAX_WRITE_LABEL
,      OLS_MIN_WRITE_LABEL
,      OLS_PRIVILEGES_GRANTED
,      OLS_PROGRAM_UNIT_NAME
,      OLS_PRIVILEGES_USED
,      OLS_STRING_LABEL
,      OLS_LABEL_COMPONENT_TYPE
,      OLS_LABEL_COMPONENT_NAME
,      OLS_PARENT_GROUP_NAME
,      OLS_OLD_VALUE
,      OLS_NEW_VALUE
,      RMAN_SESSION_RECID
,      RMAN_SESSION_STAMP
,      RMAN_OPERATION
,      RMAN_OBJECT_TYPE
,      RMAN_DEVICE_TYPE
,      DP_TEXT_PARAMETERS1
,      DP_BOOLEAN_PARAMETERS1
,      DIRECT_PATH_NUM_COLUMNS_LOADED
,      CON_ID
FROM SYS.V_$UNIFIED_AUDIT_TRAIL;

Dependencies

[top of page]

SYS.V_$UNIFIED_AUDIT_TRAIL references the following:

SYS.V_$UNIFIED_AUDIT_TRAIL is referenced by following:

PUBLIC: V$UNIFIED_AUDIT_TRAIL