Ashish Agrawal is currently Director, Product Management for IT Analytics in Oracle Management Cloud developing cloud based solutions for next-generation integrated monitoring, management, and analytics cloud services. Ashish has over 24 years of experience in IT. Ashish has expertise in Oracle Database Administration, performance tuning, Enterprise Manager, Exadata Engineered Systems, Platform as a Service, DevOps. More about Ashish on LinkedIn at www.linkedin.com/in/ashishagrawaloracle or http://tinyurl.com/ashishoracle. I have spoken previously at UKOUG, IOUG, NYOUG, Oracle OpenWorld, Full Stack Developer Conference Finland 2019, DOAG 2019.
Practical SQL Tuning and DevOps
Want to learn SQL Tuning tips, identify SQL performance patterns across all of your Oracle databases, how to diagnose SQL performance issue from application to SQL, help DevOps tune and quickly resolve SQL performance issue than this session is for you.
In DevOps model software is released in accelerated manner. This agility brings on additional challenges to release a quality software with high performing SQL workload. This session talks about Oracle tools to detect and tune problematic Oracle database SQLs, common issues that may result in bad SQL performance and methods of solving those problems. The session would cover few SQL coding tips that help avoid problems with SQL performance. This session would discuss how to diagnose performance issue from application to SQL and help DevOps quickly resolve SQL performance issue. In this session see how to recognize patterns of SQL performance issues across all of your Oracle Databases, perform a historical, comparative analysis to find any SQL bottlenecks affecting enterprise wide database performance, identify trends of SQL performance over time, identify application inefficiencies and see SQL performance anomalies and how to get to the root cause of the anomaly.