I know I 'stole' it from some web site, but can't remember where. Gives you
a start.
SELECT tablespace_name,
total_blocks,
used_blocks,
free_blocks,
total_blocks*16/1024 as total_MB,
used_blocks*16/1024 as used_MB,
free_blocks*16/1024 as free_MB
FROM v$sort_segment;
--
- So what's using the segments:
--
SELECT b.TABLESPACE,
b.segfile#,
b.segblk#,
b.blocks,
b.blocks*16/1024 as MB,
a.SID,
a.serial#,
a.status
FROM v$session a,
v$sort_usage b
WHERE a.saddr = b.session_addr
ORDER BY b.TABLESPACE,
b.segfile#,
b.segblk#,
b.blocks;
Van: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
Namens VIVEK_SHARMA
Verzonden: maandag 22 augustus 2005 13:50
Aan: oracle-l_at_freelists.org
Onderwerp: Free space in TEMP Tablespace ?
A very basic Qs :-
How do we find the FREE Space Left in TEMP Tablespace at any point while the
DB is running ?
This does NOT appear in sys.dba_free_space.
Thanks
- CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
for the use of the addressee(s). If you are not the intended recipient,
please notify the sender by e-mail and delete the original message. Further,
you are not to copy, disclose, or distribute this e-mail or its contents to
any other person and any such actions are unlawful. This e-mail may contain
viruses. Infosys has taken every reasonable precaution to minimize this
risk, but is not liable for any damage you may sustain as a result of any
virus in this e-mail. You should carry out your own virus checks before
opening the e-mail or attachment. Infosys reserves the right to monitor and
review the content of all messages sent to or from this e-mail address.
Messages sent to or from this e-mail address may be stored on the Infosys
e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Aug 22 2005 - 07:20:18 CDT