event-icon
Description

Session ID: 354

Abstract:

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.

Audience: In-Depth

Tags