Upcoming Presentation Topics on Oracle Performance
Listed below are the venues and topics I’m scheduled to present on (thus far) for 2022. Abstracts are included below.
Rocky Mountain Oracle Users Group Virtual Training Days Conference February 7 – 11, 2022:
“Performance Tuning Using the Advisor Framework”
“OCI - Architecting for Performance”
East Coast Oracle Conference February 22-24, 2022
“Database Performance Analytics Using Anomaly Detection”
Performance Tuning Using the Advisor Framework
Tired of grinding away to try to come up with a database tuning action plan? This presentation details how to get to database tuning actions more quickly by aggregating findings and recommendations across multiple Advisor runs. The author details his custom tools (simple SQL statements) that expose many undocumented features of the Advisor framework. In the DBA or developer’s hands, these tools can massively scale-up your ability to action tuning opportunities exposed by the various Advisors. The excellent findings and recommendations that come out of the various Advisors such as the SQL Tuning Advisor, the Automated Database Diagnostics Monitor (ADDM), the Segment Tuning Advisor, and the SQL Access Advisor will be of particular focus in this presentation.
OCI – Architecting for Performance
This presentation will touch on OCI basics with particular focus on the elements that go into architecting for performance. Architects have many concerns, not only must the business’s functional requirements be met, but there are other non-functional technical requirements as well, such as: scalability, reliability, performance, security, … that cross the infrastructure stack (network, memory, compute, storage). The presenter will guide you through the design decisions that go into establishing an OCI configuration that will meet the technical requirements. This will not be an OCI tutorial [as material on this is broadly available] but will summarize and highlight many of the excellent OCI capabilities.
Database Performance Analytics Using Anomaly Detection
This presentation covers the author’s unique, but strikingly simple, SQL-based approach to anomaly detection among the tens of thousands of Oracle performance metrics which are aggregated on the fly. This is essentially a jet tour through the concepts provided in the book “Dynamic Oracle Performance Analytics Using Normalized Metrics”. Subtopic areas include: Why is dynamic metrics analysis needed; comparing traditional analytical methods with the dynamic method; feature engineering; feature selection and related statistical concepts; bundling metrics according to custom taxonomies; building the performance anomaly model and reporting the results. Several case studies are highlighted to show the effectiveness of this novel approach to database performance analysis.
#oracleace #RMOUG #TD2022 #eco2022 #oracle #databasetuning #oracledatabase #SQL #DBA #databasearchitecture
