Message-Id: <10527.109037@fatcity.com> From: "Elliott, Patrick" Date: Tue, 13 Jun 2000 13:52:18 -0500 Subject: RE: help me - From Italy 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@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@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@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).