Physical Corruption: ORA-1578 PART-2
Recovering from physical corruption: 1. Using BMR when RMAN backups are available When small set of blocks are corrupted, Block Media Recovery (BMR) can be used as a recovery technique.…
Application Design and ORA – 4031
Much has been written on designing good application (which uses bind variables) so as to have better performance and avoid shared pool memory issues. Tom Kyte explains this on one…
Physical Corruption: ORA-1578 -Part 1
ORA-1578 is indication of physical block corruption. Oracle computes an internal checksum before fetching the block from disk, when it is about to fetch the block it reads the block…
Deciding “PROCESSES” parameter value
Many times we observe following error which corresponds to low setting of processes parameter. $ oerr ora 20 00020, 00000, "maximum number of processes (%s) exceeded" // *Cause: All process…
ERRORSTACK- Oracle Debugging Event
One more post arising out of my frequent visits to Oracle forum ;-) Basically there was a question on "How to set events for ORA - 1652 errors" I had…
Changing Database Characterset With Export/Import Utilities
Recently there was a thread on Oracle Forums regarding change of Database characterset from WE8ISO8859P1 to AL32UTF8. User wanted to upgrade his database from 9i to 10g and also change…