PLAN_TABLE Detils

In PLAN TABLE some of the important columns descriptions are as follows :
 
 
at
Labels:
Subscribe to: Posts (Atom)

DBMS_XPLAN

One more way we can see the Explain Plan by using DBMS_XPLAN package. DBMS_XPLAN automatically queries the last plan in PLAN_TABLE. It u...

  • Collection Methods
    The following collection methods help generalize code, make collections easier to use, and make your applications easier to maintain: ...
  • DBMS_XPLAN
    One more way we can see the Explain Plan by using DBMS_XPLAN package. DBMS_XPLAN automatically queries the last plan in PLAN_TABLE. It u...
  • Oracle SQL TRACE & TKPROF utility
    Oracle SQL TRACE utility to measure timing statistics for a given query. SQL TRACE records many vital information regarding actual query e...