Re: Problem with temp ts

From: Suhen Pather <pathers5_at_telkom.co.za>
Date: Wed, 21 Jun 2000 09:11:46 +0200
Message-Id: <10535.109944@fatcity.com>

Here is a script that can tell you what is using Temp segments. You can modify it to suit the results you are looking for

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=3D a.owner

and a.sid =3D b.sid
and b.status =3D 'ACTIVE'
and c.segment_type =3D'TEMPORARY'

Hope this works for you

Suhen Pather
Oracle DBA
Telkom SA
Tel +2712 300 4025
Cel +2782 770 9801
email pathers5_at_telkom.co.za=20

>>> stirumala72_at_yahoo.com 06/21/00 09:27AM >>>
Hello all,
How to identify the queries which are extensively using temp tablespace.
We are repeatedly facing the problem of insufficiebt space in temp tablespace.We decided to trace the query/s and tune them as much as possible as we are left with no space to allocate to temp tablespace. This problem we are facing even after making 700MB more freespace available to temp ts.
Could you please help???

thanks and regards,
Surendra
DBA,Satyam,India

Do You Yahoo!?
Send instant messages with Yahoo! Messenger. http://im.yahoo.com/=20
--=20
Author: Surendra Tirumala
INET: stirumala72_at_yahoo.com=20

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). Received on Wed Jun 21 2000 - 02:11:46 CDT