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.SAM_SPARSITY_ADVICE

Object Details

Object Name:	SAM_SPARSITY_ADVICE
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Temporary Table Details

SYS.SAM_SPARSITY_ADVICE is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000814872C00012$$	LOB	UNIQUE	SYSTEM
SYS_IL0000814872C00013$$	LOB	UNIQUE	SYSTEM

Columns

Name	Datatype	Length	Mandatory
CUBENAME	VARCHAR2	(100)	Yes
FACT	VARCHAR2	(4000)	Yes
DIMENSION	VARCHAR2	(100)	Yes
DIMCOLUMN	VARCHAR2	(100)
DIMSOURCE	VARCHAR2	(4000)
MEMBERCOUNT	NUMBER	(12)
LEAFCOUNT	NUMBER	(12)
ADVICE	VARCHAR2	(10)	Yes
POSITION	NUMBER	(4)	Yes
DENSITY	NUMBER	(11)
PARTNUM	NUMBER	(6)	Yes
PARTBY	CLOB	(4000)
PARTTOPS	CLOB	(4000)
PARTLEVEL	VARCHAR2	(200)

Query Text

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


SELECT CUBENAME
,      FACT
,      DIMENSION
,      DIMCOLUMN
,      DIMSOURCE
,      MEMBERCOUNT
,      LEAFCOUNT
,      ADVICE
,      POSITION
,      DENSITY
,      PARTNUM
,      PARTBY
,      PARTTOPS
,      PARTLEVEL
FROM SYS.SAM_SPARSITY_ADVICE;

Dependencies

[top of page]

SYS.SAM_SPARSITY_ADVICE does not reference any database object

SYS.SAM_SPARSITY_ADVICE is referenced by following:

PUBLIC: SAM_SPARSITY_ADVICE
SYS: DBMS_CUBE - show dependent code