This seminar is designed to be a primer on the Oracle Database Diagnostic and Tuning Packs. These packs have powerful tools which are not only good for DBAs but they can also help application developers test, diagnose and tune their code. The Diagnostic Pack has tools that analyze performance at the database instance level and the Tuning Pack has tools to analyze SQL statements and their access paths.
We’ll discuss how to permit non-DBA users access to these tools by discussing the privileges must be granted in the database. Since the command line is neither the easiest nor the most effective way of using the tools, the users can be set up with accounts in Oracle Enterprise Manager. We’ll discuss what is needed within OEM to give them access.