Finding a performance problems using SQL
Track
Database & Infrastructure
Date and time
Wednesday, 18. October 2023., 11:55
Room
Hall C
Duration
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.
Lecture details
About speaker
Marcin Przepiorowski, author
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 Sponsor
Venue Sponsor
Media Sponsor
HrOUG.hr
The conference is organized by the Croatian Association of Oracle users. More about the association can be found at Hroug.hr.