Hi vette86

thanks for wonderful tip regarding the sort area. i changed that to 3 MB.

Can you please tell me about the locally managed temp file. advantages and disadavantaged related to it.

btw , i had to kill the drop tablespace temp command becoz we needed DB for some other urgent work. so i started again the DROP TABLESPACE TEMP last night, it is still running. what i see now is :-

SQL> select count(*) from DBA_EXTENTS where segment_type like 'TEMP%' and
tablespace_name = 'TEMP';
COUNT(*)
----------
34200

which is going DOWN.

&
this one is going UP

SQL> select count(*) from dba_free_space where tablespace_name = 'TEMP';
COUNT(*)
----------
372110

but i think at the end it will clear off the dba_free_space table also.

correct me if i am wrong

thanks and regards
- DBKID