Message

Yes I am running 8.1.7.3 .. Is this a bug ?=20

What will I do then?

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

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

----- Original Message -----
From:=20 James Morle
To: Multiple recipients of list ORACLE-L =

Sent: Wednesday, April 03, 2002 = 9:33=20 PM

Subject: RE: ORA-00600 error =

Are you = running=20 8.1.7.3?

This is a known bug, with a = patch=20 available.

Regards

James

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

Dear Gurus ,

I am lack of UGA memory. How can I see how much uga memory is = setup for=20 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=20 C:\oracle\admin\UYBS\udump\ORA02864.TRC:
ORA-00600: internal = error code,=20 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=20 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:=20 ADALET\DALI

program:

last wait for 'SQL*Net message from client' blocking sess=3D0x0 = seq=3D1484=20 wait_time=3D-2

driver id=3D28444553, #bytes=3D1, =3D0

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

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

------=_NextPart_000_0046_01C1DBCA.30E22BD0-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: bunyamink@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@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).