Oracle-L: RE: ORA-00600 error

From: James Morle <James.Morle_at_scaleabilities.co.uk>
Date: Wed, 03 Apr 2002 10:33:27 -0800
Message-ID: <F001.0043A3F2.20020403103327@fatcity.com>

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

Regards

James

-----Original Message-----
K. Karadeniz
Sent: 03 April 2002 18:21
To: Multiple recipients of list ORACLE-L

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: James Morle
INET: James.Morle_at_scaleabilities.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). Received on Wed Apr 03 2002 - 12:33:27 CST