Intermittent ORA 600 [kdsgrp1]
From: Kumar, Arvind <arvind.kumar2_at_atos.net>
Date: Wed, 9 Jan 2013 06:58:00 +0000
Message-ID: <6F7CFB57E313784297D8B3239F60C89903EFD429_at_SGSGPTS9EM1MSX.ww931.my-it-solutions.net>
Greetings all,
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production, Windows 2008 R2 Enterprise.
Date: Wed, 9 Jan 2013 06:58:00 +0000
Message-ID: <6F7CFB57E313784297D8B3239F60C89903EFD429_at_SGSGPTS9EM1MSX.ww931.my-it-solutions.net>
Greetings all,
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production, Windows 2008 R2 Enterprise.
There is a select query which fails intermittently with ORA 600 [kdsgrp1] and generates huge .trc
ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []
- Dump for incident 795670 (ORA 600 [kdsgrp1]) ========
- 2013-01-09 13:16:35.324
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=7nkvuwm6q9rtd) -----
- 2013-01-09 13:16:35.324
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
V$active_session_history shows the select query has waited mostly on "log file sequential read" event.
analyzing the table/index with validate structure doesn't help. I have not tried _row_cr�LSE yet.
Any pointers/help will be much appreciated.
Thanks & Regards,
Arvind Kumar
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 09 2013 - 07:58:00 CET