Thursday, October 20, 2011

Ora-00600: Internal Error Code, Arguments: [Qesblget]

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:    Ora-00600: Internal Error Code, Arguments: [Qesblget]

Log files:
LOG FILE
-----------------------
Filename =
See the following error: alert_SID1.log
Mon Dec 21 12:14:48 2009
Errors in file /u01/app/oracle/product/10.2.0/admin/SID/bdump/SID1_s000_7180.trc:
ORA-00600: internal error code, arguments: [KGHALO4], [0xC0000000DB141CF8], [], [], [], [], [], []
ORA-00604: error occurred at recursive SQL level 1
ORA-02397: exceeded PRIVATE_SGA limit, you are being logged off

Solution:


Bug 7389998 ORA-600: INTERNAL ERROR CODE, ARGUMENTS: [QESBLGET] 

Apply 10.2.0.4 patchset.

or

The workaround is to set _bloom_filter_enabled = FALSE at system level and restart database to prevent use of bloom filte
References:
Ora-00600: Internal Error Code, Arguments: [Qesblget] (Doc ID 739625.1)



Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: