RE: Help ! ORA-00600 : internal error code

<<That I've resolved
setting the event 10262.>>

Sorry ..I didn't understand that bit. Can you clarify please

John

> -----Original Message-----
> From: Christian Trassens [SMTP:ctrassens_at_YAHOO.COM]
> Sent: 26 July 2001 10:37
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Help ! ORA-00600 : internal error code
>
> I enclose a metalink document that I have because of
> that error. Obsviously it is related with the PGA.
> However I add sth in contradiction with the note, I've
> seen a similar problem on 8.1.7. That I've resolved
> setting the event 10262.
>
>
> Doc ID: Note:131490.1
> big for this port (o/s)"
> Type: REFERENCE
> Status: REVIEWED
> Content Type: TEXT/PLAIN
> Creation Date: 04-JAN-2001
> Last Revision Date: 25-MAY-2001
>
>
> Note: For additional ORA-600 related information
> please read [NOTE:146580.1]
>
> PURPOSE:
> This article discusses the internal error "ORA-600
> [733]", what
> it means and possible actions. The information here
> is only applicable
> to the versions listed and is provided only for
> guidance.
>
> ERROR:
> ORA-600 [733][a][b][c][d][e]
>
> VERSIONS:
> versions 7.3.X to 8.1.X
>
> DESCRIPTION:
>
> When allocating an extent in the PGA, if the minimum
> size requested is greater
> than what is allowed for this port, ORA-00600 [733]
> is logged.
>
> Program Global Area (PGA) heap/memory allocation
> error.
>
> No data corruption occurs.
>
> ARGUMENTS:
> [733][min_size][comment]
>
> [min_size]
> The minimum extent size requested, in bytes.
>
> [comment]
> A comment supplied by the caller.
>
> FUNCTIONALITY:
> MEMORY IMPLEMENATION
>
> IMPACT:
> PROCESS FAILURE
> NON CORRUPTIVE - No corruption to underlying data.
>
> SUGGESTIONS:
> Known issues:
> Bug 553250 when trying to bind > 32K in a PL/SQL
> table, fixed in 8.1.7 release.
> If receiving this during a query with complex JOIN,
> for example, consider lowering
> sort_area_size or hash_area_size if
> hash_join_enabled = true and rerun the
> query again so the PGA memory requirements aren't as
> large.
>
>
> REgards.
>
>
>
>
> --- John Dunn <john.dunn_at_sefas.co.uk> wrote:
> > Help !
> >
> > What does this mean?
> >
> > ORA-00600: internal error cod, arguments : [733],
> > [33719116], [pga heap],
> > [], [], [], [], []
> >
> >
> > John
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: John Dunn
> > INET: john.dunn_at_sefas.co.uk
> >
> > Fat City Network Services -- (858) 538-5051 FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
>
>
> =====
> Eng. Christian Trassens
> Senior DBA
> Systems Engineer
> ctrassens_at_yahoo.com
> ctrassens_at_hotmail.com
> Phone : 541149816062
>
> __________________________________________________
> Do You Yahoo!?
> Make international calls for as low as $.04/minute with Yahoo! Messenger
> http://phonecard.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Christian Trassens
> INET: ctrassens_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Dunn
  INET: john.dunn_at_sefas.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).