Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00600 Problem

user8983130Apr 4 2010 — edited Apr 4 2010
Hi...,

Few days back,an error showed in my alert log during peak hour,when all clients were working connecting to database.I'm showing the error below:-

Errors in file d:\oracle\admin\orcl\udump\orcl_ora_3584.trc:
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo read buffer)
ORA-00600: internal error code, arguments: [6856], [0], [6], [], [], [], [], []
ORA-04030: out of process memory when trying to allocate 16360 bytes (pga heap,KD BLOCK CHECKING)

Doing block recovery for fno: 101 blk: 123274
No block recovery was needed
Sun Feb 28 14:39:49 2010
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_3584.trc:
ORA-00600: internal error code, arguments: [6856], [0], [5], [], [], [], [], []
ORA-00600: internal error code, arguments: [6856], [0], [6], [], [], [], [], []
ORA-04030: out of process memory when trying to allocate 16360 bytes (pga heap,KD BLOCK CHECKING)
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1120
ORA-06512: at "SYS.DBMS_SQL", line 323
ORA-06512: at "users.TEXT", line 206
ORA-06512: at "users.REPORT_TOOLS", line 523
ORA-06512: at line 254
ORA-06512: at line 454


As i know,there is little an dba can do in case of ORA-00600,But i m worried if these errors are a signal for big future problem????

Any suggestion...........?????

Warm Regards,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 2 2010
Added on Apr 4 2010
2 comments
1,455 views