DBA_AWS

DBA_AWS describes all analytic workspaces in the database. Its columns are the same as those in ALL_AWS.

Related Views

· ALL_AWS describes the analytic workspaces accessible to the current user.

· USER_AWS describes 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		Number of the analytic workspace
AW_NAME	VARCHAR2(30)		Name of the analytic workspace
AW_VERSION	VARCHAR2(4)		Format version of the analytic workspace: · 9.1 · 10.1 · 10.2 · 11.1
PAGESPACES	NUMBER		Number of pagespaces in the analytic workspace
GENERATIONS	NUMBER		Number of active generations in the analytic workspace
FROZEN	VARCHAR2(6)		Freeze state of the analytic workspace: · Frozen · NoThaw

Note:

1. Query the analytic workspaces in the database:

SELECT * FROM DBA_AWS;

OWNER	AW_NUMBER	AW_NAME	AW_VERSION	PAGESPACES	GENERATIONS
SYS	113	EXPRESS	10.2	36	2
SYS	114	AWMD	10.2	98	2
SYS	115	AWCREATE	10.2	21	2
SYS	116	AWCREATE10G	10.2	9	2
SYS	117	AWXML	10.2	56	2
SYS	118	AWREPORT	10.2	9	2

Oracle data dictionary views

Oracle dynamic performance views