| mohamed riaz |
Posted: May 13, 2008 11:16:25 PM |
Total Post: 95
Joined: Sep, 2006
|
Dear all,
please explain the following questions :
1) can anyone give me a suggestion for how to resolve the following errors Ora:600 (internal errors)
2) Ora : 01555 shapshot too old error
3) Deadlock errors
Thanks
|
|
|
 GOPU |
| Posted: May 13, 2008 11:25:16 PM |  |
|
Total Post: 334
Joined: Apr, 2008
|
for snapshot too old error...
ORA-01555: snapshot too old: rollback segment number string with name "string" too small
Cause: rollback records needed by a reader for consistent read are overwritten by other writers
Action: If in Automatic Undo Management mode, increase undo_retention setting. Otherwise, use larger rollback segments
yoy can refer this links also...
http://www.lazydba.com/oracle/0__116608.html
|
|
|
|
|
| GOPU |
| Posted: May 13, 2008 11:28:41 PM | |
|
Total Post: 334
Joined: Apr, 2008
|
ORA:0600
Some times it is an internal error,It may occur because of the network problems or some bad data.And also it is reported as a bug.
ORA-00600: internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
Cause: This is the generic internal error number for Oracle program exceptions. This indicates that a process has encountered an exceptional condition.
Action: Report as a bug - the first argument is the internal error number
please refer this links to get the more detail about the ORA:600
http://www.fors.com/orasupp/rdbms/dba/15206_1.HTM
|
|
|
|
|
| GOPU |
| Posted: May 13, 2008 11:30:21 PM | |
|
Total Post: 334
Joined: Apr, 2008
|
refer this link to know about the deadlocks
http://www.oracle-base.com/articles/misc/Deadlocks.php
|
|
|
|
|
| Murtuja |
| Posted: May 14, 2008 12:51:23 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Metalink have tool for ORA-600 Argument Lookup
http://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=153788.1
You can get exact information from metalink only for ORA-600 errors.
Thanks Gopu for the good link
|
|
|
|
|
| Mohammed Taj |
| Posted: May 14, 2008 04:59:02 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
As already you recevied answer.
but
Ora:600 (internal errors)
Means Oracle BUG apply latest patchset /cpu will fix this
2) Ora : 01555 shapshot too old error
Change undo_managment to AUTO and increase undo retention
3) Deadlock errors
Will automatically resolved by Oracle. It is not related to Oracle error it is simply application bug.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
