如何看表空间的uniform size

显示全部楼层 · 2005-10-30 17:05:33

谢谢！！！

千问 · 2005-10-30 17:05:33

select tablespace_name, initial_extent from dba_tablespaces
where allocation_type='UNIFORM';

千问 · 2005-10-30 17:05:33

select tablespace_name, NEXT_EXTENTfrom dba_tablespaces
where allocation_type='UNIFORM';

应该也可以把

千问 · 2005-10-30 17:05:33

最初由 applezh 发布
[B]select tablespace_name, NEXT_EXTENTfrom dba_tablespaces
where allocation_type='UNIFORM';

应该也可以把 [/B]

千问 · 2005-10-30 17:05:33

可以吗？

千问 · 2005-10-30 17:05:33

最初由 applezh 发布
[B]可以吗？ [/B]
可以，这个应该更恰当

千问 · 2005-10-30 17:05:33

select * from dba_tablespaces;
SQL> select * from dba_tablespaces;
TABLESPACE_NAME
BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE MIN_EXTLEN STATUSCONTENTSLOGGING FOR EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG
------------------------------ ---------- -------------- ----------- ----------- ----------- ------------ ---------- --------- --------- --------- --- ---------- --------- --- ------ -------- ----------- ---
SYSTEM
8192
65536
12147483645
65536 ONLINEPERMANENT LOGGING NOLOCALSYSTEMNOMANUAL DISABLED NOT APPLY NO
SYSAUX
8192
65536
12147483645
65536 ONLINEPERMANENT LOGGING NOLOCALSYSTEMNOAUTO DISABLED NOT APPLY NO
TEMP
81921048576 1048576 1
01048576 ONLINETEMPORARY NOLOGGING NOLOCALUNIFORM NOMANUAL DISABLED NOT APPLY NO
USERS
8192
65536
12147483645
65536 ONLINEPERMANENT LOGGING NOLOCALSYSTEMNOAUTO DISABLED NOT APPLY NO
TEST
8192
65536
12147483645
65536 ONLINEPERMANENT LOGGING NOLOCALSYSTEMNOAUTO DISABLED NOT APPLY NO
CAT
8192
65536
12147483645
65536 ONLINEPERMANENT LOGGING NOLOCALSYSTEMNOAUTO DISABLED NOT APPLY NO
HWM
8192
40960 40960 12147483645
040960 ONLINEPERMANENT LOGGING NOLOCALUNIFORM NOMANUAL DISABLED NOT APPLY NO
ASSM256
8192 262144262144 12147483645
0 262144 ONLINEPERMANENT LOGGING NOLOCALUNIFORM NOAUTO DISABLED NOT APPLY NO
UNDOTBS2
8192
65536
12147483645
65536 ONLINEUNDOLOGGING NOLOCALSYSTEMNOMANUAL DISABLED NOGUARANTEE NO
T
8192
65536
12147483645
65536 ONLINEPERMANENT LOGGING NOLOCALSYSTEMNOAUTO DISABLED NOT APPLY NO
T1
8192
65536
12147483645
65536 ONLINEPERMANENT LOGGING NOLOCALSYSTEMNOAUTO DISABLED NOT APPLY NO
TABLESPACE_NAME
BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE MIN_EXTLEN STATUSCONTENTSLOGGING FOR EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG
------------------------------ ---------- -------------- ----------- ----------- ----------- ------------ ---------- --------- --------- --------- --- ---------- --------- --- ------ -------- ----------- ---
T2
8192
65536
12147483645
65536 ONLINEPERMANENT LOGGING NOLOCALSYSTEMNOAUTO DISABLED NOT APPLY NO
DEMO
8192
65536
12147483645
65536 ONLINEPERMANENT LOGGING NOLOCALSYSTEMNOAUTO DISABLED NOT APPLY NO
TEMP02
81921048576 1048576 1
01048576 ONLINETEMPORARY NOLOGGING NOLOCALUNIFORM NOMANUAL DISABLED NOT APPLY NO
TS
8192 3145728031457280 12147483645
0 31457280 ONLINEPERMANENT LOGGING NOLOCALUNIFORM NOAUTO DISABLED NOT APPLY NO
15 rows selected.