Mining the AWR v2: Trend Analysis

Track

DBA & Infrasturktura

Datum i vrijeme

četvrtak, 19. listopad 2017., 14:50

Dvorana

Dvorana A

Trajanje

45'

AWR reports or AWR Difference reports are unable to show clearly how performance changes over time (specific SQLs, statistics or wait events), however, the data is captured by the snapshots and is stored in the Automatic Workload Repository. In this presentation, I will show how to access that data and in will explain at which circumstances it\'s useful to look at it to find out more about the ongoing issues. The presentation will include examples of issues being solved by using this approach or AWR mining, and will provide simple queries that every attendee will be able to use or adapt for their specific needs. The attendees will learn to troubleshoot and forecast the performance issues more efficiently after attending this presentation.

Detalji o predavanju

Vrsta: Predavanje
Razina težine: Srednje detaljno
Poželjno iskustvo slušatelja: Bez iskustva (1 g. i manje)
Poželjna funkcija slušatelja: DBA , Programeri

O predavaču

Najbolji pokrovitelj

Bolji pokrovitelj

Medijski pokrovitelj

HrOUG.hr

Konferenciju organizira Hrvatska udruga Oracle korisnika. Više o udruzi možete saznati na Hroug.hr.

Prati nas na Facebooku

Prati nas na Twitteru

Sve novosti i zanimljivosti vezane uz HrOUG objavljujemo na Twitteru!