v$sort_segment和v$tempfile显示的临时文件大小不一致。
我的数据库里只有一个tempfile,
OS:REDHAT 5
DB:ORACLE 10.2
SQL> SELECT FILE#,BYTES,BLOCKS,CREATE_BYTES,BLOCK_SIZE,NAME FROM V$TEMPFILE;
FILE#BYTES BLOCKS CREATE_BYTES BLOCK_SIZE NAME
---------- ---------- ---------- ------------ ---------- --------------------------------------------------------------------------------
1 27262976 3328 20971520 8192 /db/oracle/oradata/orcl/temp01.dbf
SQL> SELECT TABLESPACE_NAME,EXTENT_SIZE,TOTAL_EXTENTS,TOTAL_BLOCKS,MAX_SIZE,MAX_BLOCKS FROM V$SORT_SEGMENT;
TABLESPACE_NAME
EXTENT_SIZE TOTAL_EXTENTS TOTAL_BLOCKS MAX_SIZE MAX_BLOCKS
------------------------------- ----------- ------------- ------------ ---------- ----------
TEMP
128
25 3200 25 3200
|