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: CTXSYS.DR$AUTOOPT

Object Details

Object Name:	DR$AUTOOPT
Object Type:	TABLE
Owner:	CTXSYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	CTXD
PCT Free:	10
PCT Used:	40

Unique Key: DRC$AUTOOPT_UN

AOI_IDXID
AOI_PARTID
AOI_OWNID

Indexes

Index	Type	Uniqueness	Tablespace	Column
DRC$AUTOOPT_UN	NORMAL	UNIQUE	CTXD	AOI_IDXID AOI_PARTID AOI_OWNID

Columns

Name	Datatype	Length
AOI_IDXID	NUMBER
AOI_PARTID	NUMBER
AOI_OWNID	NUMBER
AOI_OWNNAME	VARCHAR2	(30)
AOI_IDXNAME	VARCHAR2	(30)
AOI_PARTNAME	VARCHAR2	(30)

Query Text

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


SELECT AOI_IDXID
,      AOI_PARTID
,      AOI_OWNID
,      AOI_OWNNAME
,      AOI_IDXNAME
,      AOI_PARTNAME
FROM CTXSYS.DR$AUTOOPT;

Dependencies

[top of page]

CTXSYS.DR$AUTOOPT does not reference any database object

CTXSYS.DR$AUTOOPT is referenced by following:

CTXSYS: CTX_AUTO_OPTIMIZE_INDEXES; CTX_USER_AUTO_OPTIMIZE_INDEXES; DRIXMD - show dependent code; DRV$AUTOOPT