Session ID: 354
The methods used to track performance issues in SQL and PL/SQL vary based on the level of access within a system. A developer in cooperation with a DBA, or already granted DBA privileges can has a wide variety of tools and deep visibility. However, a user with nothing more than CREATE SESSION and SELECT privileges can still make considerable headway into deciphering performance issues and correcting them.
Objective 1: Developers will learn a variety of built-in views with public SELECT privileges as well as tools and techniques available to assist themselves in figuring out their own application bottlenecks.
Objective 2: Provide additional information to DBAs to track application progress and explore additional tools and views available with additional privileges.
Objective 3: Detail specific privileges a developer may want/need as well as caveats associated with granting the additional privileges.