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…
Tweaking _Shared_pool_reserved_min_alloc and ORA – 4031
Here comes one more article dedicated towards diagnosing ORA- 4031 and related parameters. While googling on ORA-4031 error or working on TAR with Oracle Support you will most likely hit…
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…
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…
HW enqueue contention with LOB
Definition Enqueues are local locks that serialize access to various resources. Enqueue wait event indicates a wait for a lock that is held by another session (or sessions) in an…