select distinct b.sid,
b.serial#,
substr(b.username, 1, 8) USERNAME,
b.process,
substr(c.segment_name, 1, 8) SEGMENT_NAME,
bytes BYTES,
substr(b.osuser, 1, 7) OS_USER,
substr(b.machine, 1, 6) M_NAME,
substr(b.program, 1, 12) PROGRAM
from v$access a,
v$session b,
dba_segments c
where c.owner = a.owner
and a.sid = b.sid
and b.status = 'ACTIVE'
and c.segment_type = 'TEMPORARY';
HTH
Mark
===================================================
Mark Leith | T: +44 (0)1905 330 281
Sales & Marketing | F: +44 (0)870 127 5283
Cool Tools UK Ltd | E: [EMAIL PROTECTED]
===================================================
http://www.cool-tools.co.uk
Maximising throughput & performance
-----Original Message-----
Sent: 14 February 2003 11:49
To: Multiple recipients of list ORACLE-L
Quick question, I want to find out what sql is currently using my temporary
segments. Is their a simple solution. Am getting the ORA-1652 for my locally
managed temporary tablespace and I would like to find out what sql is
causing this. My temp tablespace is currently 1.2GB.
Oracle 8.1.7.3 on HPUX 11.
TIA
With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits
your needs
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
