Whenever I create or rebuild indexes i have been having the sort_Area_size
as 1 gig,I have never faced any issues,but one thing i want to know why did
u have to bounce the instance for this,whenever i create i add the sort area
size for the session only and not on the instance level.
we were
Arun - Thanks for the tip of using ALTER SESSION. I'll try that next time,
and I hope next time isn't too soon.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, May 28, 2002 12:32 PM
To: Multiple recipients of list ORACLE-L
Whenever I create or
Are u getting that error quite frequently
-Original Message-
Sent: Tuesday, May 28, 2002 1:52 PM
To: Multiple recipients of list ORACLE-L
Arun - Thanks for the tip of using ALTER SESSION. I'll try that next time,
and I hope next time isn't too soon.
Dennis Williams
DBA
Lifetouch, Inc.
Arun - No, I just needed to rebuild our largest table this weekend and
re-create the indexes afterward. Fortunately with SORT_AREA_SIZE at
150-meg., the indexes build in a reasonable amount of time, so it was merely
an inconvenience. I was able to enjoy one day of the weekend. I just
wondered for
Hi,
Asked you sys admin to boost the maximum memory
allowable for a process.
I had that error on a hp box. I do not remember the
name of the parameters. Once the sys admin had changed
the memory process parameters, processes were able to
use way more than 150M of ram.
You can increase the
Are you using PQO?
-Original Message-
Sent: Tuesday, May 28, 2002 12:54 PM
To: Multiple recipients of list ORACLE-L
This weekend I was rebuilding a large table and when it came time to rebuild
the indexes, I cranked the SORT_AREA_SIZE up to 1/2 gig. It bombed off with
an ORA-04030. I
One more best way also is to create those indexes with nologging along with
ur sort_area_size,this i think u must be knowing, if that database has a
standby then copy this file which has the index data
Cause as u know only the structure of the index goes to the dictionary and
not the index data
One item to remember on this note of using alter session is that if a pile of
your SQL*Plus users have the alter session privilege and set sort_area_size to a
large value at the same time, you can soon run out of memory. At which time all
of the above listed users will come down complaining
:
Sent by: Subject: Limited SORT_AREA_SIZE
[EMAIL PROTECTED
Arun - Yes, I have discovered the nologging option. Also someone asked
whether I was using parallel, and the answer is no.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, May 28, 2002 3:01 PM
To: Multiple recipients of list ORACLE-L
One more
10 matches
Mail list logo