RE: How to identify Temp Space being used

From: Xu, Roger <roger.xu_at_cs-americas.com>
Date: Wed, 4 Apr 2007 15:08:39 -0600
Message-ID: <EFB86E9035DB7F4C9A513C94F2CE7497241E94@acsemb01.americas.csplc.net>

select rpad(s.sid,5,' ') sid,

       s.username,
       rpad(s.program,15,' ') prgm,
       rpad(su.blocks*16384/(1024*1024)||' MB ',10,' ') tempsize,
       su.segtype,
       su.tablespace
from v$session s,
     v$sort_usage su

where s.saddr=su.session_addr
order by su.blocks
/

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Bala Sent: Wednesday, April 04, 2007 12:46 PM To: oracle-l
Subject: How to identify Temp Space being used

Can anyone share the sql to identify the Temp space being used by the currently running SQL in database  

Thanks much.

--

Bala Rao  

P please don't print this e-mail unless you really need to.

---

Regarding this email and attachments: This email is confidential and may contain privileged information. If you are not the intended recipient or receive it in error, you may not use, distribute, disclose or copy any of it (and such may be unlawful), and you must immediately notify and return it to us at CSAmericas- mailerror_at_csaric.com and destroy all copies. Views of individuals herein do not necessarily reflect Cadbury Schweppes Americas' or any of its subsidiaries'. This email does not constitute a binding offer, acceptance, amendment, waiver or other agreement, unless such intention is clearly stated in the email. As good computing practice, you should conduct your own virus checking. Please note that we may monitor, in accordance with applicable law, emails we receive.

NOTE: Cadbury Schweppes is phasing in a new internet mail address standard. Please check the sender address above and update your address book as required.

---

--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 04 2007 - 16:08:39 CDT