Re: ORA-600

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Wed, 21 Apr 2004 22:51:42 +0200
Message-ID: <eknd805n00ae8aiuda30a5teo4fic8atrq@4ax.com>

On Wed, 21 Apr 2004 20:23:25 +0200, "Olaf Musch" <Olaf.Musch_at_computer.org> wrote:

>"Sybrand Bakker" <gooiditweg_at_sybrandb.verwijderdit.demon.nl> schrieb im Newsbeitrag
>news:iied809sbmslkuidui61v756su8b4qg2sp_at_4ax.com...
>> On Wed, 21 Apr 2004 16:26:25 +0200, "Olaf Musch"
>> <Olaf.Musch_at_computer.org> wrote:
>>
>> >Hi all,
>> >
>> >on one of our databases (9.2.0.4, W2K server, english)
>> >we've just received an
>> >
>> >ORA-00600 internal error [733] [pga heap]
>> >
>> Why do you think the database doesn't run anymore? Any sign pointing
>> to that fact in eg. the alert log?
>
>Well, on startup of the machine, the db doesn't
>come up anymore automatically.
>
>Tryin to start it up via SQL*Plus results in this
>error and the db still not running.
>
>Signs enough?
>
>> The second argument in the ora-600 points to a memory leak. Nothing
>> more, nothing less.
>>
>Well that's what we were assuming, thanks for the hint.
>
>Do you have any recommendations what to try?
>
>Regards
>
>Olaf

Not sure it would help but if you have been bumping up pga_aggregate target, reduce it and retry.

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Apr 21 2004 - 15:51:42 CDT