Oracle-L: Re: ORA-00600 error

From: Bunyamin K. Karadeniz <bunyamink_at_havelsan.com.tr>
Date: Thu, 04 Apr 2002 00:23:22 -0800
Message-ID: <F001.0043AB5F.20020404002322@fatcity.com>

MessageYes I am running 8.1.7.3 .. Is this a bug ? What will I do then?

Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729

The degree of normality in a database
is inversely proportional to that of its DBA.

Original Message ----- From: James Morle To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 03, 2002 9:33 PM Subject: RE: ORA-00600 error

Are you running 8.1.7.3?
This is a known bug, with a patch available.

Regards

  James
    -----Original Message-----
    From: root_at_fatcity.com [mailto:root_at_fatcity.com] On Behalf Of Bunyamin K. Karadeniz     Sent: 03 April 2002 18:21
    To: Multiple recipients of list ORACLE-L     Subject: ORA-00600 error

    Dear Gurus ,
    I am lack of UGA memory. How can I see how much uga memory is setup for users and will it be enough increasing sort_area_size ?     The error is below.
    I recieve error in alert log.
    Wed Apr 03 18:19:20 2002
    Errors in file C:\oracle\admin\UYBS\udump\ORA02864.TRC:     ORA-00600: internal error code, arguments: [729], [324], [space leak], [], [], [], [], []

The ORA02864.TRC file is 900 KB.
I have selected some lines in trace file. The things I wonder in the ORA02864.TRC file is :

2002-04-03 18:19:17.187
SESSION ID:(17.792) 2002-04-03 18:19:16.875
- ERROR: UGA memory leak detected 324 ********

O/S info: user: Administrator, term: DALI, ospid: 992:1224, machine: ADALET\DALI

program:

last wait for 'SQL*Net message from client' blocking sess=0x0 seq=1484 wait_time=-2

driver id=28444553, #bytes=1, =0

    Bunyamin K. Karadeniz
    Oracle DBA / Developer
    Civilian IT Department
    Havelsan A.S. Eskisehir yolu
    7.km Ankara Turkey
    Phone: +90 312 2873565 / 1217
    Mobile : +90 535 3357729

The degree of normality in a database is inversely proportional to that of its DBA.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Bunyamin K. Karadeniz
INET: bunyamink_at_havelsan.com.tr

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). Received on Thu Apr 04 2002 - 02:23:22 CST