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

VIEW: SYS.TABCOMPARTV$

Object Details
Object Name: TABCOMPARTV$
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
OBJ# NUMBER
Yes
DATAOBJ# NUMBER

BO# NUMBER
Yes
PART# NUMBER

HIBOUNDLEN NUMBER
Yes
HIBOUNDVAL LONG (0)
SUBPARTCNT NUMBER
Yes
FLAGS NUMBER
Yes
DEFTS# NUMBER

DEFPCTFREE NUMBER
Yes
DEFPCTUSED NUMBER
Yes
DEFINITRANS NUMBER
Yes
DEFMAXTRANS NUMBER
Yes
DEFINIEXTS NUMBER

DEFEXTSIZE NUMBER

DEFMINEXTS NUMBER

DEFMAXEXTS NUMBER

DEFMAXSIZE NUMBER

DEFEXTPCT NUMBER

DEFLISTS NUMBER

DEFGROUPS NUMBER

DEFLOGGING NUMBER

DEFBUFPOOL NUMBER

ANALYZETIME DATE

SAMPLESIZE NUMBER

ROWCNT NUMBER

BLKCNT NUMBER

EMPCNT NUMBER

AVGSPC NUMBER

CHNCNT NUMBER

AVGRLN NUMBER

SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 NUMBER

PHYPART# NUMBER
Yes
Query Text

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


SELECT OBJ#
,      DATAOBJ#
,      BO#
,      PART#
,      HIBOUNDLEN
,      HIBOUNDVAL
,      SUBPARTCNT
,      FLAGS
,      DEFTS#
,      DEFPCTFREE
,      DEFPCTUSED
,      DEFINITRANS
,      DEFMAXTRANS
,      DEFINIEXTS
,      DEFEXTSIZE
,      DEFMINEXTS
,      DEFMAXEXTS
,      DEFMAXSIZE
,      DEFEXTPCT
,      DEFLISTS
,      DEFGROUPS
,      DEFLOGGING
,      DEFBUFPOOL
,      ANALYZETIME
,      SAMPLESIZE
,      ROWCNT
,      BLKCNT
,      EMPCNT
,      AVGSPC
,      CHNCNT
,      AVGRLN
,      SPARE1
,      SPARE2
,      SPARE3
,      PHYPART#
FROM SYS.TABCOMPARTV$;

Dependencies

[top of page]

SYS.TABCOMPARTV$ references the following:

SchemaSYS
TableTABCOMPART$
SYS.TABCOMPARTV$ is referenced by following:

SchemaSYS
ViewALL_IND_STATISTICS
ViewALL_TAB_STATISTICS
ViewDBA_IND_STATISTICS
ViewDBA_TAB_STATISTICS
Package BodyDBMS_STATS_INTERNAL - show dependent code
ViewUSER_IND_STATISTICS
ViewUSER_TAB_STATISTICS
View_user_stat