temp tablespace allocaton question
- From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>, <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>, <ORACLE-L@xxxxxxxxxxxxx>, <oracledba@xxxxxxxxxxx>, <oracle-rdbms@xxxxxxxxxxxxxxx>
- Date: Fri, 06 Jan 2006 11:28:11 -0500
I am looking at v$sort_segment and notice that if take total_blocks
(18848) times block size (8192) you get 147.25 M. Shouldn't this equal
the 1000M that was allocated?
SQL> select name,bytes/1024/1024 bytes_m from v$tempfile;
NAME
--------------------------------------------------------------------------------
BYTES_M
----------
F:\HASTUSTS\TEMP.DBS
1000
SQL> select * from v$sort_segment;
TABLESPACE_NAME SEGMENT_FILE SEGMENT_BLOCK EXTENT_SIZE
------------------------------- ------------ ------------- -----------
CURRENT_USERS TOTAL_EXTENTS TOTAL_BLOCKS USED_EXTENTS USED_BLOCKS
FREE_EXTENTS
------------- ------------- ------------ ------------ -----------
------------
FREE_BLOCKS ADDED_EXTENTS EXTENT_HITS FREED_EXTENTS FREE_REQUESTS
MAX_SIZE
----------- ------------- ----------- ------------- -------------
----------
MAX_BLOCKS MAX_USED_SIZE MAX_USED_BLOCKS MAX_SORT_SIZE MAX_SORT_BLOCKS
---------- ------------- --------------- ------------- ---------------
RELATIVE_FNO
------------
TEMP 0 0 8
0 2356 18848 0 0
2356
18848 0 51930 0 0
2356
18848 2249 17992 2249 17992
0
SQL>
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
Other related posts:
