Hope you find this post on Advanced Explain Plans useful!
Related Articles
utlrp weird behavior with INVAID objects in an Oracle EBS database
In one of the recent database migration & upgrade activities, I have migrated an Oracle EBS database 11.2.0.4 to a new DB host and upgraded to 12.1.0.2. After migration and post upgrade, an utlrp.sql ...
Using the All-In-One Toad Edge 2.02 with MySQL, PostgreSQL, EDB,...
MySQL and PostgreSQL are the #1 and #2 open source databases, respectively, providing complementary features to meet the requirements of any open source database developer. The latest Toad Edge (2.02)...
What is the Oracle lock table function, and how does it work?
This article will talk about an important function that we need to understand when working with an Oracle database, the Oracle LOCK TABLE. First of all, Oracle blocks information based on the transact...
