Hi Friends,

so finally my drop tablespace finished after 8 days and 3 hours. sometime oracle sucks :( ( please do not mind )

so i have question for you guys again :

1. as per my knowledege SMON awakes every 3 min and cleans the free extents from dba_extents and puts in dba_free_space.

there is nobody connected to database and still i see this quesry returning same rows

select count(*) from dba_extents where segment_type = 'TEMPORARY'

don't you think it should clear it.

i am running oracle 8.1.7 db.


FYI : Stats on my DROP TABLESPACE
- initial count on dba_extents for TEMP segment 378,560
- machine sun U2
- how long it took to drop temp tablespace - 8days + 3 hours
- it initially cleared everything from dba_extents and put it in dba_free_space and then it cleared dba_free_space

Now i am using locally managed temp file which is cool

thanks and regards
DBKID