Finding a performance problems using SQL
Track
Baza podataka i infrasturktura
Datum i vrijeme
srijeda, 18. listopad 2023., 11:55
Dvorana
Dvorana C
Trajanje
45'
SQL client like SQL*Plus or SQLDeveloper is still a very popular tool for DBA to access Oracle Database for performance troubleshooting. Together with AWR and ASH repository it can be transformed into a powerful diagnostic tool. This presentation will show how to use tables and views provided by AWR to get information not available in an easy way in graphic form. In addition to that some Oracle analytic functions will be presented so DBA can learn how to use it in day by day activity.
Detalji o predavanju
O predavaču
Marcin Przepiorowski, autor
My name is Marcin Przepiorowski. I'm working with Oracle technology stack since 2001. I'm interested in three areas - automation, DevOps, high availability (DataGuard, RAC, etc) and performance monitoring and troubleshooting. For last 10 years I'm involved in OUG community and blogger community. I presented on UKOUG, German DOAG, Polish OUG, Irish and BGOUG conferences. I'm a proud member of OakTable and Sym42
T-Shirt pokrovitelj
Pokrovitelj lokacije
Medijski pokrovitelj
HrOUG.hr
Konferenciju organizira Hrvatska udruga Oracle korisnika. Više o udruzi možete saznati na Hroug.hr.