@| My name is Marcin Przepiorowski. I’m working with Oracle technology stack since 2001. I’m interested in three areas – automation, 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. |
During Contech2024, Marcin Przepiorowski will present Finding a performance problems using SQL
| Finding a performance problems using SQL – Abstract: SQL client like SQL*Plus or SQLDeveloper is still very popular tool for DBA to access Oracle Database for performance troubleshooting. Together with AWR and ASH repository it can be transformed to powerful diagnostic tool. This presentation will show how to use tables and views provided by AWR to get information not available in 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. |