Mining the AWR v1: Alternative Methods for Identification of the Top SQLs

Track

DBA & Infrasturktura

Datum i vrijeme

srijeda, 18. listopad 2017., 09:50

Dvorana

Dvorana B

Trajanje

45'

We can use AWR reports to quickly identify the SQL_IDs of the top statements in the database. But what if the AWR report reveals no \"low-hanging fruit,\" and the resource usage is evenly distributed among multiple statements? Where do we start? Is there a better way to identify the starting point for the tuning of a resource-bound system? This presentation will explain when the AWR reports are misleading and how we can take a look at the data stored in AWR from a different angle to determine the top consumers. Discussion will include a practical demonstration using scripts for AWR mining that attendees can apply to their own challenging database performance tuning problems

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!