Originally posted by vr76413
____________________________________________________________
It shows 98% full b/c Oracle preallocated the tablespaces.
___________________________________________________


Thanks Mike2000...


I ddn't get it when u said "preallocated ". Do u mean that Oracle 9i has preallocated 'x' bytes of space for this TBS ?...

reason is , my other 9i DB TEMP tbs is only 17% Full..


any help is appreciated...

thanks
ron
Are you sure that in your other DB the TEMP tablespace is a temporary tablespace and not permanent tablespace.

Do a select tablespace_name,file_name from dba_temp_files to find out if its actually a temporary tablespace.

Because if its a LMT Temporary tablespace then the extents are
pre-allocated.

Code:
[email protected]D> create temporary tablespace TEMP_TBS tempfile 'e:/temp_tbs01.dbf' size 50M;

Tablespace created.

[email protected]D> select tablespace_name,file_id,block_id,blocks,bytes/1024/1024 from v$temp_extent_map
  2  where tablespace_name = 'TEMP_TBS';

TABLESPACE_NAME                   FILE_ID   BLOCK_ID     BLOCKS BYTES/1024/1024
------------------------------ ---------- ---------- ---------- ---------------
TEMP_TBS                                2          9        128               1
TEMP_TBS                                2        137        128               1
TEMP_TBS                                2        265        128               1
TEMP_TBS                                2        393        128               1
TEMP_TBS                                2        521        128               1
TEMP_TBS                                2        649        128               1
TEMP_TBS                                2        777        128               1
TEMP_TBS                                2        905        128               1
TEMP_TBS                                2       1033        128               1
TEMP_TBS                                2       1161        128               1
TEMP_TBS                                2       1289        128               1
TEMP_TBS                                2       1417        128               1
TEMP_TBS                                2       1545        128               1
TEMP_TBS                                2       1673        128               1
TEMP_TBS                                2       1801        128               1
TEMP_TBS                                2       1929        128               1
TEMP_TBS                                2       2057        128               1
TEMP_TBS                                2       2185        128               1
TEMP_TBS                                2       2313        128               1
TEMP_TBS                                2       2441        128               1
TEMP_TBS                                2       2569        128               1
TEMP_TBS                                2       2697        128               1
TEMP_TBS                                2       2825        128               1
TEMP_TBS                                2       2953        128               1
TEMP_TBS                                2       3081        128               1
TEMP_TBS                                2       3209        128               1
TEMP_TBS                                2       3337        128               1
TEMP_TBS                                2       3465        128               1
TEMP_TBS                                2       3593        128               1
TEMP_TBS                                2       3721        128               1
TEMP_TBS                                2       3849        128               1
TEMP_TBS                                2       3977        128               1
TEMP_TBS                                2       4105        128               1
TEMP_TBS                                2       4233        128               1
TEMP_TBS                                2       4361        128               1
TEMP_TBS                                2       4489        128               1
TEMP_TBS                                2       4617        128               1
TEMP_TBS                                2       4745        128               1
TEMP_TBS                                2       4873        128               1
TEMP_TBS                                2       5001        128               1
TEMP_TBS                                2       5129        128               1
TEMP_TBS                                2       5257        128               1
TEMP_TBS                                2       5385        128               1
TEMP_TBS                                2       5513        128               1
TEMP_TBS                                2       5641        128               1
TEMP_TBS                                2       5769        128               1
TEMP_TBS                                2       5897        128               1
TEMP_TBS                                2       6025        128               1
TEMP_TBS                                2       6153        128               1

49 rows selected.

[email protected]D>
See above, here i just created a temporary tablespace of size 50M and all extents were preallocated.

HTH