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]

TABLE: SYS.SQLOBJ$AUXDATA

Object Details

Object Name:	SQLOBJ$AUXDATA
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Indexes

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

Columns

Name	Datatype	Length	Mandatory
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

Query Text

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;

Dependencies

[top of page]

SYS.SQLOBJ$AUXDATA does not reference any database object

SYS.SQLOBJ$AUXDATA is referenced by following:

SYS: DBA_SQL_PATCHES; DBA_SQL_PLAN_BASELINES; DBA_SQL_PROFILES; DBMS_SPM_INTERNAL - show dependent code