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 best
There are limits to amount of memory a process can attach to. I have hit
that wall with the size of the SGA from time to time. I would think that
limit would be associated with the sort area also, sort_area + sga if you
will. Take a look at document
http://metalink.oracle.com/metalink/plsql/ml
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 h
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 ke
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 sor
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
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 - 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 re
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 build