Wednesday, December 17, 2008

Temp tablespace current usage.....

SQL> select tablespace_name,(total_blocks*8)/1024,(used_blocks*8)/1024,(free_blocks*8)/1024 from v$sort_segment;
TABLESPACE_NAME (TOTAL_BLOCKS*8)/1024 (USED_BLOCKS*8)/1024 (FREE_BLOCKS*8)/1024------------------------------- --------------------- -------------------- --------------------
TEMP 3328 1 3327

No comments: