Thanks slimdave,

After posting this I went to metalink and got some answers to this.

I am getting error (table or view doesnot exist) when i quried V$TEMPSEG_USAGE view. I used sys.V$TEMPSEG_USAGE still I get the same error. Do you mean v$sort_segment view ?

When I queried the above view I find over 70% of the Blocks are free.

This tells me that though the TEMP space is full by over 99% there are over 70% of free blocks.

Thanks for you reply.

-Hidayath