You can use this :
select distinct
b.sid,b.serial#,substr(b.username,1,8)USERNAME,b.process,
substr(c.segment_name,1,8)SEGMENT_NAME,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'
/
- "Klavers, Richard" <R.Klavers_at_arbeidsbureau.nl> a
icrit:
> Hi,
>
> is there a way to see which user or process is
> consuming the
> TEMP tablespace?
> The tablespace is created as a 'TEMPORARY'
> tablespace.
> I've looked in all kinds of documentation, and you
> can find all sort of
> things
> about rollback segments and memory and so on, but
> nothing is said
> about the TEMP tablespace.
>
> Regards, Richard Klavers
>
> --
> Author: Klavers, Richard
> INET: R.Klavers_at_arbeidsbureau.nl
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (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).
>
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
Received on Wed May 03 2000 - 02:38:26 CDT