Note: One of our visitors and my friend Kavita Yadav asked this question by posting a comment. Thanks KAvita for your contribution. Keep visiting/commenting! As there are over 800 wait events but but frequently you may come across very few. As working on performance tuning since more than 4 yrs there are very few wait events. [...]
Archive for December, 2011
Solving common Oracle Wait Events for performance tunning
Posted in Performance Tunning, tagged buffer busy waits, Cache buffer chain latch, Cache buffer LRU chain latch, db file scattered reads, db file sequential reads, Direct Path Reads, Direct Path Writes, enqueue waits, free buffer waits, Latch Free Waits, Library cache latch, log file parallel write, log file sync, Row cache objects latch, Shared pool latch, wait events on December 9, 2011 | 1 Comment »
Step by step oracle database upgrade from 10.2.0.2 to 10.2.0.4 (also for SAP patch as well )
Posted in Administration, tagged 10.2.0.2, 10.2.0.4, Mopatch, Oracle, Patch upgrade, SAP on December 5, 2011 | 7 Comments »
Note: One of our visitors Lokesh Suryawanshi asked this question by posting a comment. Thanks Lokesh for your contribution. As promised i did patch upgrade on yesterday and here is the details of it. Keep visiting/commenting! Required Software and Installable are available in “ */*/Patch” directory $HOME = /oracle/SAM $ORACLE_HOME = /oracle/SAM/102_64 1. 10.2.0.4 Patchset [...]
