[Home] [Help] [Dependency Information]
Object Name: | SQLOBJ$AUXDATA |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_SQLOBJ$AUXDATA_PKEY | NORMAL | UNIQUE | SYSAUX |
SIGNATURE
CATEGORY OBJ_TYPE PLAN_ID |
SYS_IL0000468305C00036$$ | LOB | UNIQUE | SYSAUX | |
I_SQLOBJ$AUXDATA_TASK | NORMAL | NONUNIQUE | SYSAUX |
TASK_ID
TASK_EXEC_NAME TASK_OBJ_ID TASK_FND_ID TASK_REC_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SIGNATURE | NUMBER | Yes | ||
CATEGORY | VARCHAR2 | (128) | Yes | |
OBJ_TYPE | NUMBER | Yes | ||
PLAN_ID | NUMBER | Yes | ||
DESCRIPTION | VARCHAR2 | (500) | ||
CREATOR | VARCHAR2 | (128) | ||
ORIGIN | NUMBER | Yes | ||
VERSION | VARCHAR2 | (64) | ||
CREATED | TIMESTAMP(6) | (11) | Yes | |
LAST_MODIFIED | TIMESTAMP(6) | (11) | ||
LAST_VERIFIED | TIMESTAMP(6) | (11) | ||
PARSE_CPU_TIME | NUMBER | |||
OPTIMIZER_COST | NUMBER | |||
MODULE | VARCHAR2 | (64) | ||
ACTION | VARCHAR2 | (64) | ||
PRIORITY | NUMBER | |||
OPTIMIZER_ENV | RAW | (2000) | ||
BIND_DATA | RAW | (2000) | ||
PARSING_SCHEMA_NAME | VARCHAR2 | (128) | ||
EXECUTIONS | NUMBER | |||
ELAPSED_TIME | NUMBER | |||
CPU_TIME | NUMBER | |||
BUFFER_GETS | NUMBER | |||
DISK_READS | NUMBER | |||
DIRECT_WRITES | NUMBER | |||
ROWS_PROCESSED | NUMBER | |||
FETCHES | NUMBER | |||
END_OF_FETCH_COUNT | NUMBER | |||
TASK_ID | NUMBER | |||
TASK_EXEC_NAME | VARCHAR2 | (128) | ||
TASK_OBJ_ID | NUMBER | |||
TASK_FND_ID | NUMBER | |||
TASK_REC_ID | NUMBER | |||
FLAGS | NUMBER | |||
SPARE1 | NUMBER | |||
SPARE2 | CLOB | (4000) | ||
TASK_CON_DBID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SIGNATURE
, CATEGORY
, OBJ_TYPE
, PLAN_ID
, DESCRIPTION
, CREATOR
, ORIGIN
, VERSION
, CREATED
, LAST_MODIFIED
, LAST_VERIFIED
, PARSE_CPU_TIME
, OPTIMIZER_COST
, MODULE
, ACTION
, PRIORITY
, OPTIMIZER_ENV
, BIND_DATA
, PARSING_SCHEMA_NAME
, EXECUTIONS
, ELAPSED_TIME
, CPU_TIME
, BUFFER_GETS
, DISK_READS
, DIRECT_WRITES
, ROWS_PROCESSED
, FETCHES
, END_OF_FETCH_COUNT
, TASK_ID
, TASK_EXEC_NAME
, TASK_OBJ_ID
, TASK_FND_ID
, TASK_REC_ID
, FLAGS
, SPARE1
, SPARE2
, TASK_CON_DBID
FROM SYS.SQLOBJ$AUXDATA;
SYS.SQLOBJ$AUXDATA does not reference any database object
SYS.SQLOBJ$AUXDATA is referenced by following:
|
|
|