Verify Physical Properties of OLAP option Multidimensional Datatypes (11.1.0)This is a featured page

Container Object


set lines110 pages 500
col aw_table_name for a25
select owner||'.'||table_name aw_table_name, securefile, encrypt,
compression, logging, cache, tablespace_name
from dba_lobs where table_name like 'AW$%';

AW_TABLE_NAME.............SEC.ENCR.COMPRE.LOGGING.CACHE......TABLESPACE_NAME
-------------------------.---.----.------.-------.----------.-----------------
SYS.AW$AWCREATE...........YES NO...NO.....YES.....YES........SYSAUX
SYS.AW$AWCREATE10G........YES NO...NO.....YES.....YES........SYSAUX
SYS.AW$AWMD...............YES NO...NO.....YES.....YES........SYSAUX
SYS.AW$AWREPORT...........YES NO...NO.....YES.....YES........SYSAUX
SYS.AW$AWXML..............YES NO...NO.....YES.....YES........SYSAUX
SYS.AW$EXPRESS............YES NO...NO.....YES.....YES........SYSAUX
DM.AW$DM..................YES NO...NO.....NONE....YES........DM
GLOBAL.AW$GLOBAL..........YES NO...NO.....NONE....YES........USERS
GLOBAL_BIEE.AW$GLOBAL.....YES NO...NO.....NONE....YES........GLOBAL

Partitions of Container Object


set lines110 pages 500
col aw_table_name for a20
col partition_name for a20

select table_owner||'.'||table_name aw_table_name, partition_name,
securefile, encrypt, compression, logging, cache
from dba_lob_partitions where table_name like 'AW$%' order by 1,2;

AW_TABLE_NAME........PARTITION_NAME.......SEC ENCR COMPRE LOGGING CACHE
-------------------- -------------------- --- ---- ------ ------- ----------
...
DM.AW$DM.............PTN1.................YES NO...NO.....NONE....CACHEREADS
DM.AW$DM.............PTNN.................YES NO...NO.....NONE....YES

Sub-Partitions of Container Object


set lines 110 pages 1000 col aw_table_name for a20
col aw_subp_name for a40

select table_owner||'.'||table_name aw_table_name,
lob_partition_name||'.'||lob_subpartition_name aw_subp_name, securefile, encrypt,
compression, logging, cache
from dba_lob_subpartitions where table_name like 'AW$%' order by 1,2;

AW_TABLE_NAME........AW_SUBP_NAME.............................SEC ENCR COMPRE LOG CACHE
-------------------- ---------------------------------------- --- ---- ------ --- ----------
...
DM.AW$DM.............SYS_LOB_P1337.SYS_LOB_SUBP1338...........YES NO...NO.....NO..CACHEREADS
DM.AW$DM.............SYS_LOB_P1337.SYS_LOB_SUBP1339...........YES NO...NO.....NO..CACHEREADS
DM.AW$DM.............SYS_LOB_P1337.SYS_LOB_SUBP1340...........YES NO...NO.....NO..CACHEREADS
DM.AW$DM.............SYS_LOB_P1337.SYS_LOB_SUBP1341...........YES NO...NO.....NO..CACHEREADS
DM.AW$DM.............SYS_LOB_P1337.SYS_LOB_SUBP1342...........YES NO...NO.....NO..CACHEREADS
DM.AW$DM.............SYS_LOB_P1337.SYS_LOB_SUBP1343...........YES NO...NO.....NO..CACHEREADS
DM.AW$DM.............SYS_LOB_P1337.SYS_LOB_SUBP1344...........YES NO...NO.....NO..CACHEREADS
DM.AW$DM.............SYS_LOB_P1337.SYS_LOB_SUBP1345...........YES NO...NO.....NO..CACHEREADS
DM.AW$DM.............SYS_LOB_P1346.SYS_LOB_SUBP1347...........YES NO...NO.....NO..YES
DM.AW$DM.............SYS_LOB_P1346.SYS_LOB_SUBP1348...........YES NO...NO.....NO..YES
DM.AW$DM.............SYS_LOB_P1346.SYS_LOB_SUBP1349...........YES NO...NO.....NO..YES
DM.AW$DM.............SYS_LOB_P1346.SYS_LOB_SUBP1350...........YES NO...NO.....NO..YES
DM.AW$DM.............SYS_LOB_P1346.SYS_LOB_SUBP1351...........YES NO...NO.....NO..YES
DM.AW$DM.............SYS_LOB_P1346.SYS_LOB_SUBP1352...........YES NO...NO.....NO..YES
DM.AW$DM.............SYS_LOB_P1346.SYS_LOB_SUBP1353...........YES NO...NO.....NO..YES
DM.AW$DM.............SYS_LOB_P1346.SYS_LOB_SUBP1354...........YES NO...NO.....NO..YES


olapdba
olapdba 		Latest page update: made by olapdba , Jan 10 2008, 12:57 PM EST (about this update About This Update olapdba Edited by olapdba

1 word added
2 words deleted

view changes
- complete history)
Keyword tags: None
More Info: links to this page

Threads for this page

There are no threads for this page.  Be the first to start a new thread.