|
Title: |
DB Time, Avg Active Sessions, and ASH -- Oracle Performance Fundamentals |
Presenter: |
John Beresniewicz |
Organization: |
Oracle America |
|
Summary: |
The session covers the fundamental concepts of DB Time and its time derivative Avg Active Sessions, the backbone of Oracle RDBMS performance management. Features like AWR, ADDM, and SPA are founded on DB Time concepts since Oracle 10g. Observability instrumentation supporting DB time analysis will be discussed, with special attention on Active Session History (ASH.) |
|
Topic: |
Database/DBaaS Administration | Track Sponsor: RMOUG Alumni |  |
|
|
Session Type: |
One Hour Session |
Target Audience: |
Database Administration |
Experience Level: |
Intermediate |
Session: |
Session 5: 02/16/2023 2:40 pm to 3:40 pm |
Location: |
ROOM 105 |
|
Biographical Sketch: |
John Beresniewicz is an Architect in the Enterprise and Cloud Manageability group at Oracle, focused mostly on the OCI Operations Insights services. He was a principal design architect for many database performance management features in Enterprise Manager since Oracle 10g. He has presented at numerous conferences and user groups about the theory and practice of managing Oracle database performance.
|
|
|