DBA Data[Home] [Help] [Dependency Information]


TABLE: SYS.AUX_STATS$

Object Details
Object Name: AUX_STATS$
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
I_AUX_STATS$ NORMAL UNIQUE TablespaceSYSTEM ColumnSNAME
ColumnPNAME
Columns
Name Datatype Length Mandatory Comments
SNAME VARCHAR2 (30) Yes
PNAME VARCHAR2 (30) Yes
PVAL1 NUMBER

PVAL2 VARCHAR2 (255)
Query Text

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


SELECT SNAME
,      PNAME
,      PVAL1
,      PVAL2
FROM SYS.AUX_STATS$;

Dependencies

[top of page]

SYS.AUX_STATS$ does not reference any database object

SYS.AUX_STATS$ is referenced by following:

SchemaSYS
Package BodyDBMS_SQLDIAG_INTERNAL - show dependent code
Package BodyDBMS_STATS - show dependent code
PL/SQL PackageDBMS_STATS_INTERNAL - show dependent code
Package BodyDBMS_STATS_INTERNAL - show dependent code