|
ALL_ |
DBA_ |
USER_ |
GV$
| V$ |
Others
ADV...
| AUD...
| FIL...
| LOB...
| PAR...
| REP...
| SEQ...
| TAB...
USER_AUDIT_SESSION: All audit trail records concerning
CONNECT and DISCONNECT
iSelfSchooling-SQL> desc USER_AUDIT_SESSION;
Name
Null? Type
----------------------------- -------- --------------------
OS_USERNAME
VARCHAR2(255)
USERNAME
VARCHAR2(30)
USERHOST
VARCHAR2(128)
TERMINAL
VARCHAR2(255)
TIMESTAMP
DATE
ACTION_NAME
VARCHAR2(28)
LOGOFF_TIME
DATE
LOGOFF_LREAD
NUMBER
LOGOFF_PREAD
NUMBER
LOGOFF_LWRITE
NUMBER
LOGOFF_DLOCK
VARCHAR2(40)
SESSIONID
NOT NULL NUMBER
RETURNCODE
NOT NULL NUMBER
CLIENT_ID
VARCHAR2(64)
SESSION_CPU
NUMBER
EXTENDED_TIMESTAMP
TIMESTAMP(6)
PROXY_SESSIONID
NUMBER
GLOBAL_UID
VARCHAR2(32)
INSTANCE_NUMBER
NUMBER
OS_PROCESS
VARCHAR2(16)
USER_AUDIT_STATEMENT: Audit trail records concerning
grant, revoke, audit, no-audit and alter system
iSelfSchooling-SQL> desc USER_AUDIT_STATEMENT;
Name
Null? Type
----------------------------- -------- --------------------
OS_USERNAME
VARCHAR2(255)
USERNAME
VARCHAR2(30)
USERHOST
VARCHAR2(128)
TERMINAL
VARCHAR2(255)
TIMESTAMP
DATE
OWNER
VARCHAR2(30)
OBJ_NAME
VARCHAR2(128)
ACTION_NAME
VARCHAR2(28)
NEW_NAME
VARCHAR2(128)
OBJ_PRIVILEGE
VARCHAR2(16)
SYS_PRIVILEGE
VARCHAR2(40)
ADMIN_OPTION
VARCHAR2(1)
GRANTEE
VARCHAR2(30)
AUDIT_OPTION
VARCHAR2(40)
SES_ACTIONS
VARCHAR2(19)
COMMENT_TEXT
VARCHAR2(4000)
SESSIONID
NOT NULL NUMBER
ENTRYID
NOT NULL NUMBER
STATEMENTID
NOT NULL NUMBER
RETURNCODE
NOT NULL NUMBER
PRIV_USED
VARCHAR2(40)
CLIENT_ID
VARCHAR2(64)
ECONTEXT_ID
VARCHAR2(64)
SESSION_CPU
NUMBER
EXTENDED_TIMESTAMP
TIMESTAMP(6)
PROXY_SESSIONID
NUMBER
GLOBAL_UID
VARCHAR2(32)
INSTANCE_NUMBER
NUMBER
OS_PROCESS
VARCHAR2(16)
TRANSACTIONID
RAW(8)
SCN
NUMBER
SQL_BIND
NVARCHAR2(2000)
SQL_TEXT
NVARCHAR2(2000)
USER_AUDIT_TRAIL: Audit trail entries relevant to the
user
iSelfSchooling-SQL> desc USER_AUDIT_TRAIL;
Name
Null? Type
----------------------------- -------- --------------------
OS_USERNAME
VARCHAR2(255)
USERNAME
VARCHAR2(30)
USERHOST
VARCHAR2(128)
TERMINAL
VARCHAR2(255)
TIMESTAMP
DATE
OWNER
VARCHAR2(30)
OBJ_NAME
VARCHAR2(128)
ACTION
NOT NULL NUMBER
ACTION_NAME
VARCHAR2(28)
NEW_OWNER
VARCHAR2(30)
NEW_NAME
VARCHAR2(128)
OBJ_PRIVILEGE
VARCHAR2(16)
SYS_PRIVILEGE
VARCHAR2(40)
ADMIN_OPTION VARCHAR2(1)
GRANTEE
VARCHAR2(30)
AUDIT_OPTION
VARCHAR2(40)
SES_ACTIONS
VARCHAR2(19)
LOGOFF_TIME
DATE
LOGOFF_LREAD NUMBER
LOGOFF_PREAD
NUMBER
LOGOFF_LWRITE
NUMBER
LOGOFF_DLOCK
VARCHAR2(40)
COMMENT_TEXT
VARCHAR2(4000)
SESSIONID
NOT
NULL NUMBER
ENTRYID
NOT NULL NUMBER
STATEMENTID
NOT NULL NUMBER
RETURNCODE
NOT NULL NUMBER
PRIV_USED
VARCHAR2(40)
CLIENT_ID
VARCHAR2(64)
ECONTEXT_ID
VARCHAR2(64)
SESSION_CPU
NUMBER
EXTENDED_TIMESTAMP
TIMESTAMP(6)
PROXY_SESSIONID
NUMBER
GLOBAL_UID
VARCHAR2(32)
INSTANCE_NUMBER
NUMBER
OS_PROCESS
VARCHAR2(16)
TRANSACTIONID
RAW(8)
SCN
NUMBER
SQL_BIND
NVARCHAR2(2000)
SQL_TEXT
NVARCHAR2(2000)
USER_AWS: Analytic Workspaces owned by the user
iSelfSchooling-SQL> desc USER_AWS;
Name
Null? Type
----------------------------- -------- --------------------
AW_NUMBER
NOT NULL NUMBER
AW_NAME
VARCHAR2(30)
PAGESPACES
NUMBER
GENERATIONS
NUMBER
USER_AW_OBJ: Objects in Analytic Workspaces owned by
the user
iSelfSchooling-SQL> desc USER_AW_OBJ;
Name
Null? Type
----------------------------- -------- --------------------
AW_NUMBER
NOT NULL NUMBER
AW_NAME
VARCHAR2(30)
OBJ_ID
NUMBER(20)
OBJ_NAME
VARCHAR2(256)
OBJ_TYPE
NUMBER(4)
PART_NAME
VARCHAR2(256)
USER_AW_PROP: Object properties in Analytic
Workspaces owned by the user
iSelfSchooling-SQL> desc USER_AW_PROP;
Name
Null? Type
----------------------------- -------- --------------------
AW_NUMBER
NOT NULL NUMBER
AW_NAME
VARCHAR2(30)
OBJ_ID
NUMBER(20)
OBJ_NAME
VARCHAR2(256)
PROPERTY_NAME
VARCHAR2(256)
PROPERTY_TYPE
VARCHAR2(4000)
PROPERTY_VALUE
VARCHAR2(4000)
FULL_PROPERTY_VALUE
CLOB
PROPERTY_VALUE_LENGTH
NUMBER
USER_AW_PS: Pagespaces in Analytic Workspaces owned
by the user
iSelfSchooling-SQL> desc USER_AW_PS;
Name
Null? Type
----------------------------- -------- --------------------
AW_NUMBER
NOT NULL NUMBER
AW_NAME
VARCHAR2(30)
PSNUMBER
NUMBER(10)
GENERATIONS
NUMBER
MAXPAGES
NUMBER
USER_BASE_TABLE_MVIEWS: All materialized views with log(s)
owned by the user in the database
iSelfSchooling-SQL> desc USER_BASE_TABLE_MVIEWS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
MASTER
NOT NULL VARCHAR2(30)
MVIEW_LAST_REFRESH_TIME
NOT NULL DATE
MVIEW_ID
NUMBER(38)
USER_CATALOG: Tables, Views, Synonyms and Sequences
owned by the user
iSelfSchooling-SQL> desc USER_CATALOG;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
NOT NULL VARCHAR2(30)
TABLE_TYPE
VARCHAR2(11)
USER_CHANGE_NOTIFICATION_REGS: change notification registrations for
current user
iSelfSchooling-SQL> desc USER_CHANGE_NOTIFICATION_REGS;
Name
Null? Type
----------------------------- -------- --------------------
REGID
NUMBER
REGFLAGS
NUMBER
CALLBACK
VARCHAR2(256)
OPERATIONS_FILTER
NUMBER
CHANGELAG NUMBER
TIMEOUT
NUMBER
TABLE_NAME
VARCHAR2(63)
USER_CLUSTERS: Descriptions of user's own clusters
iSelfSchooling-SQL> desc USER_CLUSTERS;
Name
Null?
Type
----------------------------- -------- --------------------
CLUSTER_NAME
NOT NULL VARCHAR2(30)
TABLESPACE_NAME
NOT NULL VARCHAR2(30)
PCT_FREE
NUMBER
PCT_USED
NUMBER
KEY_SIZE
NUMBER
INI_TRANS
NOT NULL NUMBER
MAX_TRANS
NOT NULL NUMBER
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENTS
NOT NULL NUMBER
MAX_EXTENTS
NOT NULL NUMBER
PCT_INCREASE
NUMBER
FREELISTS
NUMBER
FREELIST_GROUPS
NUMBER
AVG_BLOCKS_PER_KEY
NUMBER
CLUSTER_TYPE
VARCHAR2(5)
FUNCTION
VARCHAR2(15)
HASHKEYS |