Deepak HegdeComment on SCN – What, why, and how? by Understanding SCN and checkpoint in Oracle – About Oracle and morewordpress.com - Understanding SCN and checkpoint in Oracle – About Oracle and more[…] SCN and Checkpoint (1431133.1) Automatic Checkpoint Tuning (270571.1) Checkpoint Tuning and Troubleshooting Guide (147468.1) Master Note: …
Deepak HegdeMenuoracle.comAdaptive Cursors and SQL Plan Management Use bind variables that intelligently pick the right plan every time and make sure a new execution plan is …
Deepak HegdeInterested Transaction List (ITL)avdeo.com - by AdvaitThis post gives a brief idea about how Oracle locks the rows on behalf of the transactions. Before going further on locking, it will be good for you …