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…
Read Full RecipeTag: oracle
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…
Read Full Recipe
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…
Read Full Recipe
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…
Read Full Recipe
Undo Tablespace Sizing
In this post I will be discussing various types of Undo extents which can be helpful in determining cause of ORA-30036 i.e unable to extend segment by %s in undo…
Read Full Recipe
Sign on Letter to Larry Ellison on AWR and ASH Licensing
While surfing across the blog's, I found this particular link, a compaign which is aimed at getting free access to the ASH and AWR reports. I believe most of us…
Read Full Recipe