Category Archives: Troubleshoot

Predicting Oracle Transaction Rollback Time

While waiting for a large transaction to roll back, I’ve cooked this spreadsheet which can, to some extent (not precise, just estimated – use at your own risk) predict how long it will take for the rollback to complete. The … Continue reading

Posted in Oracle, Performance, Troubleshoot | Tagged , | Leave a comment

11g: handling error ORA-00752 – lost write of a data block in the PRIMARY database

With the recent (11gR1) addition of lost write detection techniques, Oracle has one more tool to help avoid data losses. Prerequisites to it are having a physical standby database applying logs and the parameters enabled in both the primary and … Continue reading

Posted in Availability, Oracle, Troubleshoot | Tagged , , , , , | Leave a comment

ASM MEMBER disks showing as CANDIDATE

Some time ago I spent a few hours troubleshooting an issue where some 20 ASM member disks went all to either CANDIDATE or PROVISIONED status after the servers were rebooted. That’s odd because if the disks were really removed from … Continue reading

Posted in Availability, Oracle, Troubleshoot | Tagged , , , , | Leave a comment

Troubleshooting ORA-600[qsmoDropPlans:1] on 11.1.0.7 SPM

Some time ago I got this error message: Errors in file /u01/app/oracle/diag/rdbms/mydb/mydb1/trace/mydb1_m000_15032.trc  (incident=354123): ORA-00600: internal error code, arguments: [qsmoDropPlans:1], [], [], [], [], [], [], [], [], [], [], [] ORA-06512: at “SYS.DBMS_SPM”, line 2444 ORA-06512: at “SYS.DBMS_SPM_INTERNAL”, line 775 … Continue reading

Posted in Troubleshoot | Tagged , , , , | Leave a comment