Oracle-L: RE: TEMP tablespace growing abnormally -Sort Area

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Tue, 14 May 2002 14:29:27 -0800
Message-ID: <F001.004608C1.20020514142927@fatcity.com>

Simon - My apologies. Tim's response was for the other problem that is getting a lot of responses. In trying to read the postings as well as get some work done here, I confused the two.

I was thinking that the response said that the loader first loads into the TEMPORARY segment, then merged with the table segment. I confused the two since they both involved "temp".

I don't have a specific solution to your problem, but my survival instincts as a crusty old DBA (but still employed) say "don't make your TEMP tablespace autoextend". It just feels like you are trolling for trouble. I am a big fan of autoextend and have it on all my datafiles except for a couple, and guess what -- TEMP is not on autoextend for me. Maybe once you lick this one, you can give talks worldwide on either a) why you should never let TEMP autoextend or b) why you're missing the best part of Oracle by not letting your TEMP autoextend. I promise I'll attend your talk. Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, May 14, 2002 4:13 PM
To: Multiple recipients of list ORACLE-L

Dennis,
I haven't seen Tim's posting !!? as regards my woos

-----Original Message-----
Sent: Tuesday, May 14, 2002 10:13 PM
To: Multiple recipients of list ORACLE-L

Simon - I think Tim has given you a good answer to your TEMP tablespace growth. I just wanted to warn you to be cautious about extremely large sizes of SORT_AREA_SIZE. This is a per-process setting, which means that if you have several processes, each process may acquire a lot of memory and the overall system memory may be overallocated. I speak from experience, bad experience.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, May 14, 2002 1:14 PM
To: Multiple recipients of list ORACLE-L

Forgot to tell you that myparameter for sort_area_size= apx. 8GB

-----Original Message-----
Sent: Tuesday, May 14, 2002 8:02 PM
To: 'ORACLE-L_at_fatcity.com'

Hi all,
Having a bad start of week.
My temp tablespace is growing abnormally -from 3GB -> 32 GB (Filled up disk).
DB is 81700 on Tru64 Unix, 120GB in size, appx 150 front-End users running billing application for appx 200,000 customer base. Initially set-up as OPS but undone though init.ora file still has PARALEL_SERVER=TRUE, only one node is active.

I've seen a refernce to OPS in relation to de-allocation of extents but can't
get further.
Any help will be appreciated.

---
CSW


-- 

Please see the official ORACLE-L FAQ: http://www.orafaq.com


-- 

Author: Simon Waibale
  INET: waibals_at_mtn.co.ug

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).


-- 

Please see the official ORACLE-L FAQ: http://www.orafaq.com


-- 

Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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).


-- 

Please see the official ORACLE-L FAQ: http://www.orafaq.com


-- 

Author: Simon Waibale
  INET: waibals_at_mtn.co.ug

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).


-- 

Please see the official ORACLE-L FAQ: http://www.orafaq.com


-- 

Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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 May 14 2002 - 17:29:27 CDT