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 merge
Simon,
If auto extend is on the tablespace and there is a runaway or resource
intensive process that is using up a great amount of temp space, Oracle
will keep expanding the size of the tablespace until you have run out of
space on the disk.
Bryan
-Original Message-
Sent: Tuesday, May
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 ext
TEMPORARY
-Original Message-
Sent: Tuesday, May 14, 2002 9:39 PM
To: Multiple recipients of list ORACLE-L
Is your TEMP tablespace set to TEMPORARY or PERMANENT?
-Original Message-
Sent: Tuesday, May 14, 2002 11:14 AM
To: Multiple recipients of list ORACLE-L
Forgot to tell y
Yes,
But this shouldn't warrant 'indefinite extension' of the TB ?!?
-Original Message-
Sent: Tuesday, May 14, 2002 9:39 PM
To: Multiple recipients of list ORACLE-L
Do you have auto extend on the temp tablespace?
Bryan
-Original Message-
Sent: Tuesday, May 14, 2002 2:10 PM
To:
I think you meant 8MB not 8GB, right?
Take a look at v$sort_usage and find these sessions that are filling the
TEMP TS.
>From there find the sql behind this temp space and try to figure out if it's
normal to allocate this space or there is a CARTESIAN join for example that
is giving you this prob
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
ov
Do you have auto extend on the temp tablespace?
Bryan
-Original Message-
Sent: Tuesday, May 14, 2002 2:10 PM
To: Multiple recipients of list ORACLE-L
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 U
Is your TEMP tablespace set to TEMPORARY or PERMANENT?
-Original Message-
Sent: Tuesday, May 14, 2002 11:14 AM
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:
