ALL_ |
DBA_ |
USER_ |
GV$
| V$ |
Others
ADV...
| AUD...
| FIL...
| LOB...
| PAR...
| REP...
| SEQ...
| TAB...
USER_ADVISOR_ACTIONS
iSelfSchooling-SQL> desc USER_ADVISOR_ACTIONS;
Name
Null? Type
----------------------------- -------- --------------------
TASK_ID
NOT NULL NUMBER
TASK_NAME
VARCHAR2(30)
REC_ID
NOT NULL NUMBER
ACTION_ID
NOT NULL NUMBER
OBJECT_ID
NUMBER
COMMAND
VARCHAR2(64)
COMMAND_ID
NOT NULL NUMBER
FLAGS
NUMBER
ATTR1
VARCHAR2(4000)
ATTR2
VARCHAR2(4000)
ATTR3
VARCHAR2(4000)
ATTR4
VARCHAR2(4000)
ATTR5
CLOB
ATTR6
CLOB
NUM_ATTR1
NUMBER
NUM_ATTR2
NUMBER
NUM_ATTR3
NUMBER
NUM_ATTR4
NUMBER
NUM_ATTR5
NUMBER
MESSAGE
VARCHAR2(4000)
USER_ADVISOR_DIRECTIVES
iSelfSchooling-SQL> desc USER_ADVISOR_DIRECTIVES;
Name
Null? Type
----------------------------- -------- --------------------
TASK_ID
NOT NULL NUMBER
TASK_NAME
VARCHAR2(30)
SOURCE_TASK_ID
NUMBER
DIRECTIVE_ID
NOT NULL NUMBER
REC_OBJ_OWNER
VARCHAR2(30)
REC_OBJ_NAME
VARCHAR2(30)
REC_ID
NUMBER
REC_ACTION_ID
NUMBER
COMMAND
VARCHAR2(64)
ATTR1
VARCHAR2(2000)
ATTR2
VARCHAR2(2000)
ATTR3
VARCHAR2(2000)
ATTR4
VARCHAR2(2000)
ATTR5
CLOB
USER_ADVISOR_FINDINGS
iSelfSchooling-SQL> desc USER_ADVISOR_FINDINGS;
Name
Null? Type
----------------------------- -------- --------------------
TASK_ID
NOT NULL NUMBER
TASK_NAME
VARCHAR2(30)
FINDING_ID
NOT NULL NUMBER
TYPE
VARCHAR2(11)
PARENT
NOT NULL NUMBER
OBJECT_ID
NUMBER
IMPACT_TYPE
VARCHAR2(4000)
IMPACT
NUMBER
MESSAGE
VARCHAR2(4000)
MORE_INFO
VARCHAR2(4000)
USER_ADVISOR_JOURNAL
iSelfSchooling-SQL> desc USER_ADVISOR_JOURNAL;
Name
Null? Type
----------------------------- -------- --------------------
TASK_ID
NOT NULL NUMBER
TASK_NAME
VARCHAR2(30)
JOURNAL_ENTRY_SEQ
NOT NULL NUMBER
JOURNAL_ENTRY_TYPE
VARCHAR2(12)
JOURNAL_ENTRY
VARCHAR2(4000)
USER_ADVISOR_LOG
iSelfSchooling-SQL> desc USER_ADVISOR_LOG;
Name
Null? Type
----------------------------- -------- --------------------
TASK_ID
NOT NULL NUMBER
TASK_NAME
VARCHAR2(30)
EXECUTION_START
DATE
EXECUTION_END
DATE
STATUS
VARCHAR2(11)
STATUS_MESSAGE
VARCHAR2(4000)
PCT_COMPLETION_TIME
NUMBER
PROGRESS_METRIC
NUMBER
METRIC_UNITS
VARCHAR2(64)
ACTIVITY_COUNTER
NUMBER
RECOMMENDATION_COUNT
NUMBER
ERROR_MESSAGE
VARCHAR2(4000)
USER_ADVISOR_OBJECTS
iSelfSchooling-SQL> desc USER_ADVISOR_OBJECTS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_ID
NOT NULL NUMBER
TYPE
VARCHAR2(64)
TYPE_ID
NOT NULL NUMBER
TASK_ID
NOT NULL NUMBER
TASK_NAME
VARCHAR2(30)
ATTR1
VARCHAR2(4000)
ATTR2
VARCHAR2(4000)
ATTR3
VARCHAR2(4000)
ATTR4
CLOB
ATTR5
VARCHAR2(4000)
USER_ADVISOR_PARAMETERS
iSelfSchooling-SQL> desc USER_ADVISOR_PARAMETERS;
Name
Null? Type
----------------------------- -------- --------------------
TASK_ID
NOT NULL NUMBER
TASK_NAME
VARCHAR2(30)
PARAMETER_NAME
NOT NULL VARCHAR2(30)
PARAMETER_VALUE
NOT NULL VARCHAR2(4000)
PARAMETER_TYPE
VARCHAR2(10)
IS_DEFAULT
VARCHAR2(1)
IS_OUTPUT
VARCHAR2(1)
IS_MODIFIABLE_ANYTIME
VARCHAR2(1)
DESCRIPTION
VARCHAR2(4000)
USER_ADVISOR_RATIONALE
iSelfSchooling-SQL> desc USER_ADVISOR_RATIONALE;
Name
Null?
Type
----------------------------- -------- --------------------
TASK_ID
NOT NULL NUMBER
TASK_NAME
VARCHAR2(30)
REC_ID
NUMBER
RATIONALE_ID
NOT NULL NUMBER
IMPACT_TYPE
VARCHAR2(4000)
IMPACT
NUMBER
MESSAGE
VARCHAR2(4000)
OBJECT_ID
NUMBER
TYPE
VARCHAR2(30)
ATTR1
VARCHAR2(4000)
ATTR2
VARCHAR2(4000)
ATTR3
VARCHAR2(4000)
ATTR4
VARCHAR2(4000)
ATTR5
CLOB
USER_ADVISOR_RECOMMENDATIONS
iSelfSchooling-SQL> desc USER_ADVISOR_RECOMMENDATIONS;
Name
Null? Type
----------------------------- -------- --------------------
REC_ID
NOT NULL NUMBER
TASK_ID
NOT NULL NUMBER
TASK_NAME
VARCHAR2(30)
FINDING_ID
NUMBER
TYPE
VARCHAR2(30)
RANK
NUMBER
PARENT_REC_IDS
VARCHAR2(4000)
BENEFIT_TYPE
VARCHAR2(4000)
BENEFIT
NUMBER
ANNOTATION_STATUS
VARCHAR2(11)
FLAGS
NUMBER
USER_ADVISOR_SQLA_REC_SUM
iSelfSchooling-SQL> desc USER_ADVISOR_SQLA_REC_SUM;
Name
Null? Type
----------------------------- -------- --------------------
TASK_ID
NUMBER
TASK_NAME
VARCHAR2(30)
REC_ID
NUMBER
TOTAL_STMTS
NUMBER
TOTAL_PRECOST
NUMBER
TOTAL_POSTCOST
NUMBER
USER_ADVISOR_SQLA_WK_MAP
iSelfSchooling-SQL> desc USER_ADVISOR_SQLA_WK_MAP;
Name
Null? Type
----------------------------- -------- --------------------
TASK_ID
NUMBER
TASK_NAME
VARCHAR2(30)
WORKLOAD_ID
NUMBER
WORKLOAD_NAME
VARCHAR2(30)
USER_ADVISOR_SQLA_WK_STMTS
iSelfSchooling-SQL> desc USER_ADVISOR_SQLA_WK_STMTS;
Name
Null? Type
----------------------------- -------- --------------------
TASK_ID
NOT NULL NUMBER
TASK_NAME
VARCHAR2(30)
WORKLOAD_ID
NOT NULL NUMBER
WORKLOAD_NAME
VARCHAR2(30)
SQL_ID
NOT NULL NUMBER
HASH_VALUE
NUMBER
USERNAME
VARCHAR2(30)
MODULE
VARCHAR2(64)
ACTION
VARCHAR2(64)
CPU_TIME
NUMBER
BUFFER_GETS
NUMBER
DISK_READS
NUMBER
ELAPSED_TIME
NUMBER
ROWS_PROCESSED
NUMBER
EXECUTIONS
NUMBER
PRECOST
NUMBER
POSTCOST
NUMBER
LAST_EXECUTION_DATE
DATE
PRIORITY
NUMBER
COMMAND_TYPE
NUMBER
STAT_PERIOD
NUMBER
SQL_TEXT
CLOB
IMPORTANCE
NUMBER
REC_ID
NUMBER
VALIDATED
NUMBER
USER_ADVISOR_SQLW_COLVOL
iSelfSchooling-SQL> desc USER_ADVISOR_SQLW_COLVOL;
Name
Null? Type
----------------------------- -------- --------------------
WORKLOAD_ID
NOT NULL NUMBER
WORKLOAD_NAME
VARCHAR2(30)
TABLE_OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
UPDATE_FREQ
NUMBER
UPDATED_ROWS
NUMBER
USER_ADVISOR_SQLW_JOURNAL
iSelfSchooling-SQL> desc USER_ADVISOR_SQLW_JOURNAL;
Name
Null? Type
----------------------------- -------- --------------------
WORKLOAD_ID
NOT NULL NUMBER
WORKLOAD_NAME
VARCHAR2(30)
JOURNAL_ENTRY_SEQ
NOT NULL NUMBER
JOURNAL_ENTRY_TYPE
VARCHAR2(12)
JOURNAL_ENTRY
VARCHAR2(4000)
USER_ADVISOR_SQLW_PARAMETERS
iSelfSchooling-SQL> desc USER_ADVISOR_SQLW_PARAMETERS;
Name
Null?
Type
----------------------------- -------- --------------------
WORKLOAD_ID
NOT NULL NUMBER
WORKLOAD_NAME
VARCHAR2(30)
PARAMETER_NAME
NOT NULL VARCHAR2(30)
PARAMETER_VALUE
NOT NULL VARCHAR2(4000)
PARAMETER_TYPE
VARCHAR2(10)
DESCRIPTION
VARCHAR2(4000)
USER_ADVISOR_SQLW_STMTS
iSelfSchooling-SQL> desc USER_ADVISOR_SQLW_STMTS;
Name
Null?
Type
----------------------------- -------- --------------------
WORKLOAD_ID
NOT NULL NUMBER
WORKLOAD_NAME
VARCHAR2(30)
SQL_ID
NOT NULL NUMBER
HASH_VALUE
NUMBER
USERNAME
VARCHAR2(30)
MODULE
VARCHAR2(64)
ACTION
VARCHAR2(64)
CPU_TIME
NUMBER
BUFFER_GETS
NUMBER
DISK_READS
NUMBER
ELAPSED_TIME
NUMBER
ROWS_PROCESSED
NUMBER
EXECUTIONS
NUMBER
OPTIMIZER_COST
NUMBER
LAST_EXECUTION_DATE
DATE
PRIORITY
NUMBER
COMMAND_TYPE
NUMBER
STAT_PERIOD
NUMBER
SQL_TEXT
CLOB
VALID
NUMBER
USER_ADVISOR_SQLW_SUM
iSelfSchooling-SQL> desc USER_ADVISOR_SQLW_SUM;
Name
Null? Type
----------------------------- -------- --------------------
WORKLOAD_ID
NOT NULL NUMBER
WORKLOAD_NAME
VARCHAR2(30)
DESCRIPTION
VARCHAR2(256)
CREATE_DATE
NOT NULL DATE
MODIFY_DATE
NOT NULL DATE
NUM_SELECT_STMT
NUMBER
NUM_UPDATE_STMT
NUMBER
NUM_DELETE_STMT
NUMBER
NUM_INSERT_STMT
NUMBER
NUM_MERGE_STMT
NUMBER
SOURCE
VARCHAR2(30)
HOW_CREATED
VARCHAR2(30)
DATA_SOURCE
VARCHAR2(2000)
READ_ONLY
VARCHAR2(5)
USER_ADVISOR_SQLW_TABLES
iSelfSchooling-SQL> desc USER_ADVISOR_SQLW_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
WORKLOAD_ID
NUMBER
WORKLOAD_NAME
VARCHAR2(30)
SQL_ID
NUMBER
TABLE_OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
USER_ADVISOR_SQLW_TABVOL
iSelfSchooling-SQL> desc USER_ADVISOR_SQLW_TABVOL;
Name
Null? Type
----------------------------- -------- --------------------
WORKLOAD_ID
NOT NULL NUMBER
WORKLOAD_NAME
VARCHAR2(30)
TABLE_OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
UPDATE_FREQ
NUMBER
INSERT_FREQ
NUMBER
DELETE_FREQ
NUMBER
DIRECT_LOAD_FREQ
NUMBER
UPDATED_ROWS
NUMBER
INSERTED_ROWS
NUMBER
DELETED_ROWS
NUMBER
DIRECT_LOAD_ROWS
NUMBER
USER_ADVISOR_SQLW_TEMPLATES
iSelfSchooling-SQL> desc USER_ADVISOR_SQLW_TEMPLATES;
Name
Null? Type
----------------------------- -------- --------------------
WORKLOAD_ID
NOT NULL NUMBER
WORKLOAD_NAME
VARCHAR2(30)
DESCRIPTION
VARCHAR2(256)
CREATE_DATE
NOT NULL DATE
MODIFY_DATE
NOT NULL DATE
SOURCE
VARCHAR2(30)
READ_ONLY
VARCHAR2(5)
USER_ADVISOR_TASKS
iSelfSchooling-SQL> desc USER_ADVISOR_TASKS;
Name
Null? Type
----------------------------- -------- --------------------
TASK_ID
NOT
NULL NUMBER
TASK_NAME
VARCHAR2(30)
DESCRIPTION
VARCHAR2(256)
ADVISOR_NAME
VARCHAR2(30)
CREATED
NOT NULL DATE
LAST_MODIFIED
NOT
NULL DATE
PARENT_TASK_ID
NUMBER
PARENT_REC_ID
NUMBER
EXECUTION_START
DATE
EXECUTION_END
DATE
STATUS
VARCHAR2(11)
STATUS_MESSAGE
VARCHAR2(4000)
PCT_COMPLETION_TIME
NUMBER
PROGRESS_METRIC
NUMBER
METRIC_UNITS
VARCHAR2(64)
ACTIVITY_COUNTER
NUMBER
RECOMMENDATION_COUNT
NUMBER
ERROR_MESSAGE
VARCHAR2(4000)
SOURCE
VARCHAR2(30)
HOW_CREATED
VARCHAR2(30)
READ_ONLY
VARCHAR2(5)
ADVISOR_ID
NOT NULL NUMBER
USER_ADVISOR_TEMPLATES
iSelfSchooling-SQL> desc USER_ADVISOR_TEMPLATES;
Name
Null? Type
----------------------------- -------- --------------------
TASK_ID
NOT NULL NUMBER
TASK_NAME
VARCHAR2(30)
DESCRIPTION
VARCHAR2(256)
ADVISOR_NAME
VARCHAR2(30)
CREATED
NOT NULL DATE
LAST_MODIFIED
NOT NULL DATE
SOURCE
VARCHAR2(30)
READ_ONLY
VARCHAR2(5)
USER_ALL_TABLES: Description of all object and
relational tables owned by the user's
iSelfSchooling-SQL> desc USER_ALL_TABLES;
Name
Null?
Type
----------------------------- -------- --------------------
TABLE_NAME
VARCHAR2(30)
TABLESPACE_NAME
VARCHAR2(30)
CLUSTER_NAME
VARCHAR2(30)
IOT_NAME
VARCHAR2(30)
STATUS
VARCHAR2(8)
PCT_FREE
NUMBER
PCT_USED
NUMBER
INI_TRANS
NUMBER
MAX_TRANS
NUMBER
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENTS
NUMBER
MAX_EXTENTS
NUMBER
PCT_INCREASE
NUMBER
FREELISTS
NUMBER
FREELIST_GROUPS
NUMBER
LOGGING
VARCHAR2(3)
BACKED_UP
VARCHAR2(1)
NUM_ROWS
NUMBER
BLOCKS
NUMBER
EMPTY_BLOCKS
NUMBER
AVG_SPACE
NUMBER
CHAIN_CNT
NUMBER
AVG_ROW_LEN
NUMBER
AVG_SPACE_FREELIST_BLOCKS
NUMBER
NUM_FREELIST_BLOCKS
NUMBER
DEGREE
VARCHAR2(10)
INSTANCES
VARCHAR2(10)
CACHE
VARCHAR2(5)
TABLE_LOCK
VARCHAR2(8)
SAMPLE_SIZE
NUMBER
LAST_ANALYZED
DATE
PARTITIONED
VARCHAR2(3)
IOT_TYPE
VARCHAR2(12)
OBJECT_ID_TYPE
VARCHAR2(16)
TABLE_TYPE_OWNER
VARCHAR2(30)
TABLE_TYPE
VARCHAR2(30)
TEMPORARY
VARCHAR2(1)
SECONDARY
VARCHAR2(1)
NESTED
VARCHAR2(3)
BUFFER_POOL
VARCHAR2(7)
ROW_MOVEMENT
VARCHAR2(8)
GLOBAL_STATS
VARCHAR2(3)
USER_STATS
VARCHAR2(3)
DURATION
VARCHAR2(15)
SKIP_CORRUPT
VARCHAR2(8)
MONITORING
VARCHAR2(3)
CLUSTER_OWNER
VARCHAR2(30)
DEPENDENCIES
VARCHAR2(8)
COMPRESSION
VARCHAR2(8)
DROPPED
VARCHAR2(3)
USER_AQ_AGENT_PRIVS:
iSelfSchooling-SQL> desc USER_AQ_AGENT_PRIVS;
Name
Null? Type
----------------------------- -------- --------------------
AGENT_NAME
NOT NULL VARCHAR2(30)
HTTP_ENABLED
VARCHAR2(4)
SMTP_ENABLED
VARCHAR2(4)
USER_ARGUMENTS: Arguments in object accessible to the user
iSelfSchooling-SQL> desc USER_ARGUMENTS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_NAME
VARCHAR2(30)
PACKAGE_NAME
VARCHAR2(30)
OBJECT_ID
NOT NULL NUMBER
OVERLOAD
VARCHAR2(40)
ARGUMENT_NAME
VARCHAR2(30)
POSITION
NOT NULL NUMBER
SEQUENCE
NOT NULL NUMBER
DATA_LEVEL
NOT NULL NUMBER
DATA_TYPE
VARCHAR2(30)
DEFAULT_VALUE
LONG
DEFAULT_LENGTH
NUMBER
IN_OUT
VARCHAR2(9)
DATA_LENGTH
NUMBER
DATA_PRECISION
NUMBER
DATA_SCALE
NUMBER
RADIX
NUMBER
CHARACTER_SET_NAME
VARCHAR2(44)
TYPE_OWNER
VARCHAR2(30)
TYPE_NAME
VARCHAR2(30)
TYPE_SUBNAME
VARCHAR2(30)
TYPE_LINK
VARCHAR2(128)
PLS_TYPE
VARCHAR2(30)
CHAR_LENGTH
NUMBER
CHAR_USED
VARCHAR2(1)
USER_ASSOCIATIONS: All assocations defined by the user
iSelfSchooling-SQL> desc USER_ASSOCIATIONS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
VARCHAR2(30)
OBJECT_TYPE
VARCHAR2(9)
STATSTYPE_SCHEMA
VARCHAR2(30)
STATSTYPE_NAME
VARCHAR2(30)
DEF_SELECTIVITY
NUMBER
DEF_CPU_COST
NUMBER
DEF_IO_COST
NUMBER
DEF_NET_COST
NUMBER
INTERFACE_VERSION
NUMBER
USER_ATTRIBUTE_TRANSFORMATIONS
iSelfSchooling-SQL> desc USER_ATTRIBUTE_TRANSFORMATIONS;
Name
Null? Type
----------------------------- -------- --------------------
TRANSFORMATION_ID
NOT NULL
NUMBER
NAME
NOT NULL VARCHAR2(30)
FROM_TYPE
VARCHAR2(61)
TO_TYPE
VARCHAR2(91)
ATTRIBUTE
NOT NULL NUMBER
ATTRIBUTE_TRANSFORMATION
VARCHAR2(4000)
USER_AUDIT_OBJECT: Audit trail records for statements
concerning objects, specifically: table, cluster, view, index, sequence,
[public] database link, [public] synonym, procedure, trigger, rollback
segment, tablespace, role, user
iSelfSchooling-SQL> desc USER_AUDIT_OBJECT;
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_OWNER
VARCHAR2(30)
NEW_NAME
VARCHAR2(128)
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_POLICIES: All fine grained auditing policies for
objects in user schema
iSelfSchooling-SQL> desc USER_AUDIT_POLICIES;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_NAME
NOT NULL VARCHAR2(30)
POLICY_NAME
NOT NULL VARCHAR2(30)
POLICY_TEXT
VARCHAR2(4000)
POLICY_COLUMN
VARCHAR2(30)
PF_SCHEMA
VARCHAR2(30)
PF_PACKAGE
VARCHAR2(30)
PF_FUNCTION
VARCHAR2(30)
ENABLED
VARCHAR2(3)
SEL
VARCHAR2(3)
INS
VARCHAR2(3)
UPD
VARCHAR2(3)
DEL
VARCHAR2(3)
AUDIT_TRAIL
VARCHAR2(12)
POLICY_COLUMN_OPTIONS
VARCHAR2(11)
USER_AUDIT_POLICY_COLUMNS: Users fine grained auditing policy
columns in the database
iSelfSchooling-SQL> desc USER_AUDIT_POLICY_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_SCHEMA
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
POLICY_NAME
NOT NULL VARCHAR2(30)
POLICY_COLUMN
NOT NULL VARCHAR2(30)
|