OCI Database Management Cloud Service

OCI Database Management Cloud Service

Session Abstract: Oracle delivers a new comprehensive cloud-native database management cloud service with rich features for monitoring and diagnosing performance problems and compute usage on both cloud and on-premises environments. This technical session will include screen watch demonstrations highlighting common use cases, extensibility, and how to use the tool. Learn how this product is positioned in the Oracle Manageability suite of native cloud-based services and licensed products. Don’t miss the following key takeaway.

– Learn technical capabilities and see common use case demonstrations

Speaker BIO: Sriram Vrinda
Principal Product Manager, Oracle

Experienced Product Manager with a demonstrated history of working in the information technology and services industry. Strong product management professional skilled in Oracle Database, Oracle Autonomous Databases, IT Service Management, Data Warehousing, and Pre-sales. Responsible for product management, roadmap, and strategy for Oracle Database’s autonomous database manageability solutions, Oracle Cloud Observability and Management Platform, and Oracle Enterprise Manager products.

Information Life Cycle Management: Manage Exponential Data Growth

Information Life Cycle Management: Manage Exponential Data Growth

The exponential increase of data volumes puts enterprise IT infrastructures under pressure in cost, performance, scalability, and manageability. The regulatory requirements are changing, like how and why data are retained. Many organisations are now required to maintain and control more information for a more extended period. Information Lifecycle Management (ILM) is applying policies for the effective management of information throughout its useful life. Oracle’s Advanced Compression and Data Partitioning help organisations to deploy ILM policy. The benefits include improving enterprise application’s performance, reducing infrastructure cost, providing governance, risk, and compliance framework for enterprise data.

This session will cover in-depth data portioning, advance compression and database performance benefits. I will also discuss Automatic Data Optimization and Heat Map to define policies, move data to different storage tires with examples, and use Data / Information Lifecycle Management cases.

An Hour dedicated for Database & Application Performance

An hour dedicated for Database & Application Performance

Session Abstract: When I started my career as an Oracle DBA, it was Oracle 8i which was just released. Since then, we have come a long way. Each version of the Database introduced features aimed to improve the performance of an Application. This also means that many of these features are rarely used. In this 1 hour, let’s talk about database performance and do’s and don’ts for maintaining a Scalable Application. I will walk you all through some real-life examples on Database Indexing, SQL Optimization and Oracle Optimizer.

Vivek Sharma
Technical Lead – Data Warehousing Development & Global Leaders Program, Oracle

Vivek Sharma is a Technical Lead with Data Warehousing Development and Global Leaders Program. He primarily focuses on Oracle Autonomous Data Warehouse. In his current role, Vivek works with Oracle Strategic Customers across JAPAC on the Successful Implementation of Autonomous Data Warehouse Solution.

Vivek has an overall experience of around 25 years with around 19 years on Oracle Technologies. He likes to work on challenging issues and had been instrumental in resolving highly escalated issues around Database Performance, Optimizer, etc. Vivek blogs on his real-life challenges on viveklsharma.wordpress.com

 

Migrate to Oracle Cloud Infrastructure with Ease

Migrate to Oracle Cloud Infrastructure with Ease

Migrate to Oracle Cloud Infrastructure with Ease: Use Enterprise Manager Migration Workbench to Consolidate,  Migrate, and Analyze Databases to OCI, Exadata Cloud or On-premise Data Centre

Oracle is revolutionizing how data is managed with the introduction of the world’s first self-driving database. Oracle Enterprise Manager offers a unified, cost-effective, and easy way to automate the migration of your on-premises database workloads to the next generation of the industry-leading database, Oracle Autonomous  Database, eliminating human labour and error. For Database Cloud Services running on Oracle Cloud Infrastructure or Exadata Cloud at Customer, Enterprise Manager helps DBA’s, consolidate databases and assess the success of the migration. Reap benefits from automated migrations, seamlessly transferred configurations, and periodic  synchronization of data with production. Join this session to learn more.

Akshay Sangaonkar
Senior Principal Consulting Product Manager at Oracle, Oracle

Akshay is Senior Principal Product Manager for Database Manageability and Enterprise Manager for past 8 years. In his 20 years of experience, he led various teams across engineering and development, project management, technology consulting and product management. He currently focuses on Database Migration and Consolidation, Database Self Service Experience and Database Fleet Management.

Oracle 21C : Data Guard Broker New Features

Oracle 21c : Data Guard Broker New Features

Session Title: Oracle 21C: Data Guard Broker New Features

Session Abstract: Oracle 21c is released with some new features. In this session, we will talk about the new features for the Data Guard Broker. We will see how to :

-) Prepare our database for a Data Guard environment
-) Validate our Fast Start Failover configuration
-) Configure Failover Callout Configuration Scripts
-) See changes about the observer
-) Easily create Far_Sync
-) The default location for Client-side Broker Files
-) See the de-supported features
-) And many other things
-) We will analyze and give feedback about these new features.

This session contains many demos and is for all DBA using Broker configuration in a Data Guard environment.

Speaker BIO: Mouhamadou DIAW
Consultant chez Dbi Services, dbi-services
Mouhamadou Diaw OCM 12c ACE Associate

I have more than fifteen years of experience in IT domains.
I am specialized in Oracle technologies (engineered system, architecture, backup and recovery, high availability, security, audit, etc.).
I am Oracle Database 12c Administrator Certified Master, Oracle Database 12c Maximum Availability Certified Master,
-)Oracle Database 11g Security Certified, EDB Postgres Advanced Server 9.5 Professional and CISA (Isaca).
-)I received a Doctorate from INSA Toulouse, France.
-)I like football and Formula 1

If you are AIOUG Member – Click Register Button
If you are a Non-AIOUG Member – Please sign up for “Starter (FREE) Membership* and Register

Thanks,
Team AIOUG

 

Mouhamadou DIAW
Consultant chez Dbi Services, dbi-services

Mouhamadou Diaw OCM 12c ACE Associate

  • I have more than fifteen years of experience in IT domains.
  • I am specialized in Oracle technologies (engineered system, architecture, backup and recovery, high availability, security, audit etc.).
  • I am Oracle Database 12c Administrator Certified Master, Oracle Database 12c Maximum Availability Certified Master,
  • Oracle Database 11g Security Certified, EDB Postgres Advanced Server 9.5 Professional and CISA (Isaca).
  • I received a Doctorate of INSA Toulouse, France.
  • I like football and Formula 1

3-in-1: New Features for DBA’s in Oracle 18c/19c/21c(20c) – Part 2

3-in-1: New Features for DBA's in Oracle 18c/19c/21c(20c) - Part 2

Session Title : 3-in-1: New Features for DBA’s in Oracle 18c/19c/21c(20c) – Part 2

Session Abstract: This session covers the most important and relevant 100 new features in the Oracle 18c, 19c & 21c (21c) database. Oracle DBA/Develops can take advantage of those new features. The list includes a wide variety of generic features, performance tuning related enhancements, touching multi-tenant improvements, some overhauled features, and as well as security posture features. Join this session and surely you will take away a lot and loads of new features in the latest release of the Oracle database

Speaker BIO: Suresh Gandhi
Senior Manager, Qualcomm India Pvt Limited

Suresh Gandhi is Senior Manager in Qualcomm India Pvt Limited leading database teams. He has 20 years of experience in Databases, Middleware & Management. He is volunteering as Independent Director for the Independent Australia Oracle User Group (AUSOUG). For more than 7 years, he shares his learnings & knowledge in his blog  and presented various topics in AIOUG, IAOUG, AUSOUG, APACOUC, and Oracle Code One events in APAC regions. Alongside Oracle knowledge, he added proficiency in Big Data and NoSQL Databases. Suresh also experienced in designing new generation data lakes for Enterprise Datawarehouse using Cloud platforms like AWS & Oracle Cloud. He has 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 Data lakes, NoSQL Technologies. He strives to adapt to the latest trends in database technology in his work and shares his experiences with the community. He is reachable at [masked] or @geeksinsights at Twitter or leaves a comment on his blog.

Registration Link: http://bit.ly/3cuv1sP

If you are AIOUG Member – Click Register Button
If you are a Non-AIOUG Member – Please sign up for “Starter (FREE) Membership* and Register

Thanks,
Team AIOUG

Suresh Gandhi
Senior Manager, Qualcomm India Pvt Limited

Suresh Gandhi is Senior Manager in Qualcomm India Pvt Limited leading database teams. He has 20 years of experience in Databases, Middleware & Management. He is volunteering as Independent Director for Independent Australia Oracle User Group (AUSOUG). From more than 7 years, he shares his learnings & knowledge in his blog (http://db.geeksinsight.com) and presented various topics in AIOUG, IAOUG, AUSOUG, APACOUC and Oracle Code One events in APAC regions. Alongside Oracle knowledge, he added proficiency in Big Data and NoSQL Databases.  Suresh also experienced in designing new generation data lakes for Enterprise Datawarehouse using Cloud platforms like AWS & Oracle Cloud.  He has 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 Data lakes, NoSQL Technologies. He strives to adapt to the latest trends in database technology in his work and shares his experiences with the community. He is reachable at db@geeksinsight.com or @geeksinsights at twitter or leaves a comment on his blog.

What the Heck is the Oracle Optimizer Doing? Part 2 – Plan Costing

O que diabos o Oracle Optimizer está fazendo? Parte 2 - Plano de custos

Session Abstract:

When Oracle optimizes your SQL, it works out what it thinks is the best way to execute your statement to retrieve your data as quickly as possible, minimising unnecessary resource usage.

This presentation will look at what Oracle is doing. We will use the 10053 trace functionality to show how Oracle uses statistics to cost your SQL access paths, showing what cost really means and how it works, and the impact of messing with system statistics on your database.

<strong><span data-preserver-spaces=”true”>Note:</span></strong><span data-preserver-spaces=”true”> This webinar session not planned for recording, please attend the live session only.

 

Imagem
Neil Chandler
Database Guy, Chandler Systems

Neil has been working in IT since 1988, and with Oracle software since 1991.

He is an independent consultant who specialises in Performance Tuning, RAC, DataGuard, Goldengate, Upgrades, Data Migration, with some PL/SQL and Apex Development for good measure.

He likes to drink strong smooth Italian coffee, good beer and better whisky, depending upon the time of day.

Neil is an Oracle ACE Director, and a board member of the UKOUG

Exadata Storage Server Internals

Exadata Storage Server Internals

 

Storage is one of the most critical tiers in any database technology, The Exadata Storage Server runs the Exadata Storage Server Software and it provides several features like Smart Scan, Smart Flash Cache, Smart Flash Logging, IO Resource Manager, Storage Indexes and Hybrid Columnar Compression. Managing them becomes very important, take a deep dive into Exadata Storage Server Internals to know more on it.

Karan Dodwal (OCM) ♠
Karan Dodwal
Oracle Exadata Consultant, Fidelity International

Karan Dodwal is an Oracle ACE and Oracle Certified Master (OCM) with specialization in Oracle Cloud, Oracle Exadata and Performance Tuning, he works with Fidelity International as a Exadata DMA. He is an OTN Author where he frequently publishes articles on OTN, OTN Portuguese, OTN Spanish. He is a speaker and technical evangelist for All India Oracle Users Group where he presents sessions on Oracle Technology in various events like Sangam and OGYatra. In his free time he helps Oracle Users in Oracle Community through different forums. He has set up several Oracle High Availability Environments on all platforms for mission-critical Oracle Databases.

Migrating MySQL from AWS to OCI

From: https://www.aioug.org/events/migrating-mysql-from-aws-to-oci

MySQL engineering team supported MySQL Database Service (MDS) is now available on the Gen 2 Oracle Cloud Infrastructure (OCI). There is huge interest in moving MySQL workloads to the Oracle cloud because of its cost-effectiveness. Customers also want the best possible support available to them from the MySQL engineering team. This talk will give you insights to help move your MySQL workloads to OCI. We will share best practices, tips and tools to ensure that you are able to make this move effectively and fast.

Agile and DevOps for the Oracle Cloud

From: https://www.aioug.org/events/agile-and-devops-for-the-oracle-cloud

Get to know Oracle’s solution for managing the lifecycle of your code and the development process for your team. In this session we’ll demonstrate Oracle’s offering for code version management continuous integration and delivery (CI/CD) and agile team collaboration – all integrated in one tool available as part of your Oracle cloud account. Get to know Oracle Visual Builder Studio and how it can improve your team development across infrastructure, database, and applications c