Re: Space Usage in temporary tablespace

anish wrote:
>
> I am working on a database on which the temporary tablespace
> databfile(1 datafile only) is autoextensible.After executing a large
> process the file grew to 9 GB. I added another file to the same
> tablespace of size 100M .The new file got 100% filled up (saw it using
> TOAD) .Now i remove the file of 9GB size .Add another file of 2 GB
> (where autoextensible is no )and remove the smaller file of size
> 100m.Now when i see the space usage of 2GB file using TOAD it is
> 100%.How can this be possible.Because I have removed the file of 9 GB
> ,used intermediate file of 100M and then finally used a file of
> 2GB.The space usage in the 2GB file should be at most 100M.
> I am working on 9.2.0.5.

try using v$sort_usage

hth
Connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------