RE: help me - From Italy

From: Elliott, Patrick <Patrick.Elliott_at_bestbuy.com>
Date: Tue, 13 Jun 2000 13:52:18 -0500
Message-Id: <10527.109037@fatcity.com>

First of all, why do you have it set to permanent? Why not make it temporary?
Once you get this done, issue the following query to find out how much sort space is being used by the sessions.

select s.osuser,
       s.process,
       p.spid,
       s.username,
       io.sid,
       s.serial#,
       status,
       decode(a.name,'UNKNOWN',' ',a.name)        cmdname,
       lockwait,
       block_gets + consistent_gets logical_reads,
       physical_reads,
       block_changes + consistent_changes logical_writes,
       sum(u.blocks)*vp.value/1024 sort_size
from   v$session          s,
       v$process          p,
       sys.audit_actions  a,
       v$sess_io      io,
       v$sort_usage   u,
       v$parameter      vp
where  io.sid    = s.sid
  and  s.command = a.action

  and s.paddr = p.addr
  and s.saddr = u.session_addr
  and vp.name = 'db_block_size'
group by s.osuser, s.process, p.spid, s.username, io.sid, s.serial#,

       status, a.name, lockwait, block_gets, consistent_gets, physical_reads,

       block_changes, consistent_changes, vp.value /

> -----Original Message-----
> From: aaa bbbb [SMTP:antoidone_at_visto.com]
> Sent: Tuesday, June 13, 2000 10:33 AM
> To: Multiple recipients of list ORACLE-L
> Subject: help me - From Italy
>
> Hi,
>
> I'm italian from Rome, on HP9000 and DBMS (7.3.4) size 700 GBytes of
> production
> i have a problem with tablespace TEMP size 5 Gb setting
> permanent,pctincrease 0; i.e ORA-1652 because have a large order, i want
> see from SYS's segment_name in Temp the relative process SID that has
> create it and is making this large ordering.
>
> Thanks
>
> Antonio Idone
> DBA Tim
> Rome
> __________________________________________________________________________
> _
> Visit http://www.visto.com/info, your free web-based communications
> center.
> Visto.com. Life on the Dot.
>
> --
> Author: aaa bbbb
> INET: antoidone_at_visto.com
>
> 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 Tue Jun 13 2000 - 13:52:18 CDT