O'Reilly logo

Oracle APEX 4.2 Reporting by Vishal Pathak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Discussions on database tools for performance tuning

We will now have a look at a few database tools that can help us understand the performance bottlenecks, and can help us tune our APEX applications. An understanding of these tools can change our development perspective, and help us code better APEX applications.

Using PL/SQL hierarchical profiler and DBMS_PROFILER

PL/SQL hierarchical profiler is new to Oracle11g, and can help us find the execution time taken by individual subprograms called from a function. It also gives the time taken by the SQL and the PL/SQL engines to fulfill a call to a function. We can create the necessary tables for hierarchical profiler by executing the dbmshptab.sql script. The raw data collector component of the profiler ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required