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

VIEW: SYS.CDB_AW_PS

Object Details
Object Name: CDB_AW_PS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Pagespaces in Analytic Workspaces owned by the user in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30) Yes Owner of the Analytic Workspace
AW_NUMBER NUMBER
Yes
AW_NAME VARCHAR2 (128)
Name of the Analytic Workspace
PSNUMBER NUMBER (10)
Number of the pagespace
GENERATIONS NUMBER

Number of active generations in the pagespace
MAXPAGES NUMBER

Maximum pages allocated in the pagespace
CON_ID NUMBER

container id
Query Text

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


SELECT OWNER
,      AW_NUMBER
,      AW_NAME
,      PSNUMBER
,      GENERATIONS
,      MAXPAGES
,      CON_ID
FROM SYS.CDB_AW_PS;

Dependencies

[top of page]

SYS.CDB_AW_PS does not reference any database object

SYS.CDB_AW_PS is referenced by following:

SchemaPUBLIC
SynonymCDB_AW_PS