Sign in or 
Share this
Determine Version, Amount of Pagespaces and Generations in OLAP option Multidimensional Datatypes
col aw format a30 heading "AW Name"
select owner||'.'||aw_name aw, aw_number "AW No.", aw_version "Ver.",
pagespaces "Pg Spcs", generations "Gens."
from dba_aws
order by owner, aw_name;
AW Name..................AW No. Ver.....Pg Spcs......Gens.
-------------------- ---------- ---- ---------- ----------
SCOTT.TEST1................1038 10.2...... 1079..........2
SCOTT.TEST2................1037 10.2...... 1079..........2
SYS.AWCREATE................102 10.2........ 21..........2
SYS.AWCREATE10G............ 103 10.2..........9..........2
SYS.AWMD....................101 10.2........ 98..........2
SYS.AWREPORT................105 10.2..........9..........2
SYS.AWXML.................. 104 10.2........ 56..........2
SYS.EXPRESS................ 100 10.2........ 36..........2
select owner||'.'||aw_name aw, aw_number "AW No.", aw_version "Ver.",
pagespaces "Pg Spcs", generations "Gens."
from dba_aws
order by owner, aw_name;
AW Name..................AW No. Ver.....Pg Spcs......Gens.
-------------------- ---------- ---- ---------- ----------
SCOTT.TEST1................1038 10.2...... 1079..........2
SCOTT.TEST2................1037 10.2...... 1079..........2
SYS.AWCREATE................102 10.2........ 21..........2
SYS.AWCREATE10G............ 103 10.2..........9..........2
SYS.AWMD....................101 10.2........ 98..........2
SYS.AWREPORT................105 10.2..........9..........2
SYS.AWXML.................. 104 10.2........ 56..........2
SYS.EXPRESS................ 100 10.2........ 36..........2
olapdba |
Latest page update: made by olapdba
, Apr 17 2008, 12:24 PM EDT
(about this update
About This Update
more content
- olapdba
No content added or deleted. - complete history) |
|
Keyword tags:
None
More Info: links to this page
|
There are no threads for this page.
Be the first to start a new thread.
