DBA_AW_PS

DBA_AW_PS describes the pagespaces in all analytic workspaces in the database.

Related View

USER_AW_PS describes the pagespaces in the analytic workspaces owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the analytic workspace
AW_NUMBER	NUMBER	NOT NULL	Number of the analytic workspace
AW_NAME	VARCHAR2(30)		Name of the analytic workspace
PSNUMBER	NUMBER(10)		Number of the pagespace
GENERATIONS	NUMBER		Number of active generations in the pagespace

See Also: "USER_AW_PS" Oracle9i OLAP User's Guide for more information about this view