Storage Management in Oracle -3
Storage Management in Oracle -3 In article we will learn creating tablespaces with storage parameters(DEMO). Before reading this article please check previous articles. Storage Management in Oracle -2 Demo On Storage Management : To view information about storage management use DBA_TABLESPACES or V$TABLESPACE
1 2 3 4 5 6 7 8 9 10 11 |
SYS>> desc dba_tablespaceselect TABLESPACE_NAME,EXTENT_MANAGEMENT,INITIAL_EXTENT,NEXT_EXTENT,MIN_EXTENTS,MAX_EXTENTS,PCT_INCREASE from dba_tablespaces; TS-Name Extent-Man Init-Ext Next-Ext Min-Ext Max-Ext Pct-Inc ---------- ---------- ---------- ---------- ---------- ---------- ---------- SYSTEM DICTIONARY 16384 16384 1 505 50 SYSAUX LOCAL 65536 1 2147483645 UNDOTBS1 LOCAL 65536 1 2147483645 TEMP LOCAL 1048576 1048576 1 0 USERDATA LOCAL 65536 1 2147483645 TEST LOCAL 65536 1 2147483645 6 rows selected. |
Note… Read More