Identification of Performance Problems without the Diagnostic Pack


DBA & Infrasturcture

Date and time

Wednesday, 14. October 2015., 09:00


Hall 2 Castle



The Diagnostic Pack, which is an option available for the Enterprise Edition of Oracle Database only, gives access to a number of dynamic performance views and to the Automatic Workload Repository (AWR). Both are very useful for the identification of performance problems. On the one hand, dynamic performance views are mainly used for the analysis of performance problems while they are occurring. On the other hand, AWR is aimed at the analysis of performance problems that occurred in the past.The aim of this presentation is to describe how to perform analyses similar to those that can be carried out with the tools provided by the Diagnostic Pack even if you don’t have it.

Lecture details

Type: Lecture
Level of difficulty: Detailed
Experience Level: Experienced
Desirable listeners function: DBA , Developers , System Analist , Team leader
Group of activity: DBA

About speaker

The conference is organized by the Croatian Association of Oracle users. More about the association can be found at

Follow us on Facebook

Follow us on Twitter

Keep yourself up to date with all updates!

Best Sponsor

Better Sponsor

Good Sponsor

Media Sponsor