RE: ORA-00600 error

[James Morle]

Title: Message

Bunyamin,   It's bug id 2177050. The bug report talks about temp tables, but that's a red herring really - it happens without temp tables being used. Cheers   James -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bunyamin K. Karadeniz Sent: 04 April 2002 09:23 To: Multiple recipients of list ORACLE-L Subject: Re: ORA-00600 error Yes 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 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.