1. Ensure I can reproduce.
2. Read the trace file
3. Use metalink search - well it might work one day.
4. use the 0600 checker.
5. Log a tar with either the problem statement or the problem statement plus the results of the steps above if useful.
6 attach alert.log, the trace file & RDA
7. Wait for support to ask to use remote conferencing...
In this case step 4 had found the article you are presumably looking at, but
a) it isn 't obviously a query.
b) 514mb is one hell of a lot of ram to ask for from the PGA.
so I considered the suggestions for a 0600-733 to be irrelevant, and anyway i couldn 't export the spfile before I changed the settings :(
The 0600 lookup is a great note though.
Niall
-- --Original Message-- --
From: oracle-l-bounce@(protected) on behalf of Markus Reger
Sent: Wed 05/05/2004 16:18
To: oracle-l@(protected)
Cc:
Subject: Antw: More spfile goodness
doesn 't say a word about corrupt spfile. is a problem with sort_area_size =
and might be resolved by some pfile or spfile params.
kr=20
> > > n-litchfield@(protected) 05.05.2004 11:33:52 > > >
A while back we had a conversation about the advisability or not of using =
spfiles. IIRC what I suggested was sensible if you were going to use them =
was that you create a backup first using the create pfile from spfile =
command. I ran into this today
=20
SQL > create pfile from spfile;
create pfile from spfile
*
ERROR at line 1:
ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [733], [538970160], [pga heap], =
[], [], [], [], []
=20
The 733 argument shows that is essentially an out of memory condition, the =
second argument is the amount of memory in bytes requested!=20
=20
This is apparently due to a corrupt spfile - per support.=20
=20
Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805=20
=20
**********************************************************************
This email contains information intended for
the addressee only. It may be confidential
and may be the subject of legal and/or
professional privilege. Any dissemination,
distribution, copyright or use of this
communication without prior permission of
the sender is strictly prohibited.
**********************************************************************
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)=20
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/=20
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html=20
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
