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


TABLE: SYS.PS$

Object Details
Object Name: PS$
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_PS$ NORMAL UNIQUE TablespaceSYSTEM ColumnAWSEQ#
ColumnPSNUMBER
ColumnPSGEN
SYS_IL0000226353C00008$$ LOB UNIQUE TablespaceSYSTEM
Columns
Name Datatype Length Mandatory Comments
AWSEQ# NUMBER
Yes
PSNUMBER NUMBER (10)
PSGEN NUMBER (10)
MAPOFFSET NUMBER

MAXPAGES NUMBER

ALMAP RAW (8)
HEADER RAW (200)
GELOB BLOB (86)
GELREC NUMBER

MAPREC NUMBER

Query Text

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


SELECT AWSEQ#
,      PSNUMBER
,      PSGEN
,      MAPOFFSET
,      MAXPAGES
,      ALMAP
,      HEADER
,      GELOB
,      GELREC
,      MAPREC
FROM SYS.PS$;

Dependencies

[top of page]

SYS.PS$ does not reference any database object

SYS.PS$ is referenced by following:

SchemaSYS
ViewALL_AWS
ViewALL_AW_PS
ViewDBA_AWS
ViewDBA_AW_PS
ViewUSER_AWS
ViewUSER_AW_PS