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.
Performance Diagnostics and Tuning with and without your DBA
Read the full whitepaper
Premium Content: access is limited to Quest Corporate and Professional members.
Membership has its perks. Get unlimited access to the latest Oracle updates, event session replays, strategic content centers and special members-only programming, plus big discounts on conference registration, with a Quest Corporate or Professional membership. Quest is where you learn.