What we're about
Upcoming events (2)
Timings Details 08:30 to 09:00 Registrations 09:00 to 09:15 AIOUG Updates 09:15 to 09:30 Keynote from College 09:30 to 10:00 Tea/Coffee/Networking Break 10:00 to 12:00 Performance Tuning 12:00 to 13:30 Lunch 13:30 to 15:30 DevOps for DBAs 15:30 to 16:00 Tea/Coffee/Networking Break 16:00 to 16:30 Q&A 16:30 to 17:00 Closing Performance Tuning: 2 hours Session Query Processing - SQL Processing in Oracle - SQL Execution Life Cycle & Reading Execution Plans Wait Events : Latch Series - Latch Cache Buffer Chains - Buffer Busy Waits - Buffer Free Waits - Shared Pool Latch/Library Cache Lock Performance Troubleshooting Series - Understanding your Oracle Database Load - Understanding your database load from Metrics – Part 2 - Understanding where the database time is spending – Time Model Statistics - Performance Troubleshooting Series: Understanding I/O Wait - - - Performance of Oracle Database - Understanding Database CPU – Consumers – Waiters – Average Active Sessions - Troubleshooting Instance Memory Structures (SGA + PGA) Usage - Identifying Problematic Sessions or Queries (Preface) - Identifying Problematic Sessions or Queries (Method 1) - Performance Troubleshooting Series: Query Parsing & Execution Times - Performance Troubleshooting Series : Identifying or Estimating How - much PGA needed by Session/Query SQL Plan Flexibility & Stability Features - Oracle SQL Plan Stability and Flexibility features from 8i to 12c with demo snippets covering Cursor sharing, Dynamic Sampling, Cardinality - Feedback, Adaptive Cursor Sharing, 12c Adaptive Query Optimization features , SQL Profiles & Baselines with one sample use case. This presentation helps participants to understand various plan flexibility features in conjunction with Stability features DevOps for DBA: 2 hours Session DevOps for DBA – Introduction Part 1 - Docker & Vagrant - Demo on Building Vagrant Box - Provisioning Oracle DB with Ansible Part 2 - Oracle Container Registry - Provision Docker container for Oracle DB - Oracle Cloud - CLI/PSM - Terraform for OCI Speaker Bio: Suresh Gandhi is an Oracle Consultant & Blogger. He got vast experience in managing databases, especially in Oracle in various domains like Education, Insurance, Banking & Telecom. He is working with Qualcomm as Senior Manager and also Independent Director for Independent Australia Oracle User Group (AIOUG). He shares his learnings & knowledge in his blog (http://db.geeksinsight.com) and presented various events in APACOUC, AIOUG, IAOUG, AUSOUG. Alongside Oracle Database knowledge, he added proficiency in BigData and NOSQL Databases. Suresh also designed a new generation datalakes and scalable ETL Pipelines for Enterprise Dataware housing using Cloud platforms like AWS & Oracle Cloud. He got adept knowledge in DevOps & Automations. He is certified in Oracle, AWS & ITIL Certified and holds a bachelor’s degree. He is also a trainer and delivered many sessions & Webinars in Performance Troubleshooting, Building Datalakes, NoSQL Technologies. He strives to adapt the latest trends in database technology in his work and shares his experiences with community. He is reachable at [masked] or https://twitter.com/geeksinsights Registration Link: https://www.meraevents.com/event/aioug-chennai-techday-april-2019?ucode=organizer
DevOps and Databases – Managing Data in a Cloud Native Era Oracle presents a full day session for all developers, data analysts, and DevOps engineers to dive deep into Oracle’s Autonomous database offering, and understand how it ties-in with modern cloud-native apps to manage all the data. How is Data Management different today than it used to be? Well, to begin with, there is a gazillion times more data today than there used to be just a decade ago. Clearly, traditional tools of data management are not going to work. Let’s take a look at ways to manage enterprise data at scale without getting a PhD in database administration. We all wear multiple hats in this cloud era so whether you are a developer, DBA, IT Ops or DevOps, this session is for you. We’ll also look at terraform based orchestration, ways to deploy microservices on a Kubernetes cluster and whip up some python/java apps quickly in the Oracle cloud. Meet the Autonomous experts at Oracle, sign-up for a free trial of the Oracle Cloud, run the Autonomous Database labs with us on the Oracle Cloud, and get your cloud coach sessions to help with more. Agenda: Time Session 9:00 to 9:30 Registrations 9:30 to 10:00 Tea/Coffee Networking session 10:00 to 12:00 AIOps Keynote: When Data Meets AI - Sandesh Rao VP, AIOps and Autonomous Database 12:00 to 13:00 Networking Lunch 13:30 to 15:30 Autonomous Database Lab - Malay Kumar Khawas - Jayshree Chatterjee - Nitin Bhagat - Ashish Singh - Prasanna Shasthri - Varsha Bhatnagar 15:30 to 16:00 Wrap up! The Lab Flow: Lab 1: Provisioning an Autonomous Database. Lab 2: Managing and Scaling Data using Autonomous Features. Lab 3: Configuring a Node.js app (as an example) to work with the Autonomous Database. Lab 4: Understanding and Working with REST APIs. Lab 5: Configuring Infrastructure Lab 6: Modern App Dev on Oracle’s Cloud Native Framework with Oracle Autonomous as the Backend, Database Layer. Lab 7: Working with REST APIs Lab 8: Building Microservices on ATP Lab 9: Mastering DevOps in the Cloud Who Can Attend: • Enterprise, full-stack developers who want to understand how to manage the data layers for any app dev initiative using Autonomous Transaction Processing. • Developers who are interested in understanding how any micro-services or serverless style app can integrate with a database. • Data analysts and data engineers who want to understand how they can provision data marts and use advanced analytics (via various ML models) to sieve through large volumes of enterprise data using the Autonomous Data Warehouse. Prerequisite: BYOL (Bring Your Own Laptop) Registration: Please use the following link to register https://www.meraevents.com/event/become-heroes-of-autonomous-chennai?ucode=organizer Imp Note: Your application goes into a curation process with Oracle. If you are shortlisted, you shall receive an email to confirm your attendance.