|
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. |
dbainblk.gif
Description: GIF image
The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification.
tech.gif
Description: GIF image
