Choose currency

plan table in oracle 11g

Flash Recovery Area in Oracle 11g

Flash Recovery Area is the most powerful tool available from Oracle 10g, that plays a vital role in performing database backup & recovery operations. From Oracle 11g release2, flash recovery area is called as fast recovery area.
Flash Recovery Area can be defined as a single, centralized, unified storage area that keep all the database […]

How to use Explain Plan Oracle 11g


When an SQL statement is passed to the server the Cost Based Optimizer (CBO) uses database statistics to create an execution plan which it uses to navigate through the data. Once you’ve highlighted a problem query the first thing you should do is EXPLAIN the statement to check the execution plan that […]