Performance Tuning Day
Sale Date Ended
AIOUG-NIChapter Performance Tuning Day
Date & Venue: November 24th, 2018 @ Tech Mahindra Chandigarh
Key Speaker: Vivek Sharma
Technology is Evolving and so is the job of an Oracle DBA. Most organizations are either moving to Cloud or exploring Cloud as it provides not only the technological advantage, but also reduction in Operational Cost. This means, most of the Operational Tasks of a DBA are taken over by the Cloud Service Providers (CSP) but one area that these CSP’s doesn’t own is Performance Optimization.
Oracle Autonomous Database changed this drastically by providing a Self Securing, Self Driving and Self Tuning Solution. However, with these Self Managing Databases, there are few area’s that require specialized skill set and this is again Performance Optimization. Can Autonomous Database Optimize a badly written Query or Issues due to Bad Physical Design?
Being a Subject Matter Expert for Exadata Cloud and Autonomous Database for Oracle Asia-Pacific, I will walk you through some of the real life examples on some of the performance challenges with Live Demo. 24th November 2018 @ Chandigarh, I will be speaking on this topic.
Agenda
- Important to know Critical Database Concepts to know the Internal Workings of an Oracle Database
- Database Tools and Performance Features
o SQL Monitoring
o Active Session History
o AWR
o ADDM
- Query Optimizer, Transformation and Optimization
- Parallel Processing and how it works with Autonomous Databases
- Exadata and Autonomous Databases
In between Q&A to make it a memorable and learning event.
Bio of Vivek Sharma
Vivek Sharma is a Technologist with Oracle Core Technology & Cloud Team at Asia Pacific. Vivek has over 20 years of experience working on Database Architecture, Consulting and Performance Optimization. Vivek utilizes this experience to support Oracle’s key customers with some of the most critical and challenging performance problems when it comes to the Oracle Database. As an Oracle Database Expert, Vivek spends most of his time assisting the customers to get best out of their Oracle Systems and Database Investment. He assists customers across Asia Pacific on various systems including SPARC, x86 and Oracle Engineered systems such as Exadata. His core area of expertise includes Performance Optimization of Oracle Database and the Applications atop Oracle Database. Working closely with Oracle’s Engineering Teams, Vivek also regularly brings Customer Experiences and Issues from the field to the Engineers that design and create Oracle Technologies. He plays an all-important role as a bridge between Oracle Customers and Engineers as part of the EEE program. Outside of speaking at events, Vivek also contributes articles through his blog and OTN. You can find some of Vivek’s contributions here: Blog: viveklsharma.wordpress.com
AGENDA
AIOUG – NI Chapter Performance Tuning Day |
||||
Oracle Performance Tuning |
||||
TOPICS |
|
Speakers |
Session Time |
|
AIOUG-NIC Updates |
|
NIC Team |
10:00 to 10:15 |
|
Internal Working of an Oracle Database. |
|
Vivek Sharma |
10:15 to 11:15 |
|
Database tools and Performance Features |
|
Vivek Sharma |
11:15 to 12:10 |
|
TEA BREAK - 15 Minutes |
||||
Query Optimizer, Transformation and Optimization |
|
Vivek Sharma |
12:15 to 13:15 |
|
LUNCH BREAK - 45 Minutes |
||||
Parallel Processing and how it works with Autonomous Databases |
|
Vivek Sharma |
14:00 to 15:00 |
|
Exadata and Autonomous Databases |
|
Vivek Sharma |
15:00 to 16:00 |
|
WRAP UP – [Raffle & Goodies Distribution] - 15 Minutes |
Follow Us @
http://www.aioug.org/aiougnichapter.php
https://www.facebook.com/AIOUG.NIC
https://twitter.com/nichapter_aioug
https://www.youtube.com/user/aiougnic
https://aiougnic.wordpress.com/