Day: June 15, 2009

How to identify PL/SQL performance bottlenecks using DBMS_PROFILER

Leave a Comment / Oracle / By / June 15, 2009 / , , , , , , , ,

The DBMS_PROFILER package provides an interface to profile existing PL/SQL applications and identify performance bottlenecks. You can then collect and persistently store the PL/SQL profiler data. This package enables the collection of profiler (performance) data for performance improvement or for determining code coverage for PL/SQL applications. Application developers can use code coverage data to focus …

How to identify PL/SQL performance bottlenecks using DBMS_PROFILER Read More »

DBMS_XPLAN.DISPLAY_CURSOR does not display execution plan of all children associated with the SQL_ID

Leave a Comment / Oracle / By / June 15, 2009 / , , , ,

To display the execution plan of all children associated with the SQL ID; you would have to call the table function in below format. Following steps will load two children cursors in the cursor cache By querying V$SQL, We can see that SQL_ID gfvh124qr5nzy has two childrens, 0 and 1; Let us execute DBMS_XPLAN.DISPLAY_CURSOR with …

DBMS_XPLAN.DISPLAY_CURSOR does not display execution plan of all children associated with the SQL_ID Read More »