DB Viscosity Training PART 3: ORACLE DATABASE PERFORMANCE TUNING

Join ODTUG and Viscosity for a hands-on virtual class that introduces upgrading to Oracle 19c. In this class, students will get hands-on experience with on how to tune your Oracle database 19c. 

We have a limited number of user IDs available for the hands-on lab, so be sure to register quickly as a "Hands-On Participant" or for the HOL Waiting List. Registration is unlimited for those interested in only watching/listening.

Oracle database upgrades often lead to performance related issues. This is due to the number of underlying technical changes in software, introduction of new features, and general enhancement of the products. With many 19c upgrades going on, it’s good to know how to use the many technical features in Oracle for dealing with or even eliminating performance issue. 

In this lab we will go through some of the basic skills that every DBA should have around performance tuning from enhance explain plans and gathering statistics to using SQL Plan Management. We will also cover the differences between SQL Baselines and SQL profiles. This session should be good if you are an experienced DBA just brushing up on your skills, or new to using Oracle database performance tuning tools.


Outline: 

1. 19c upgrade / Lab setup 

     A. MOS Reading 

     B. Profiles vs Baselines 

     C. Optimizer Decision Tree

2. SQL Explain Plan + Lab 

     A. Normal 

     B. Plan statics 

     C. Monitor 

     D. Finding your statements

3. Database Statistics + Lab 

     A. Automated jobs 

     B. Checking object staleness 

4. SQL Plan Management (SPM) / Baselines + Lab 

     A. Create a baseline 

     B. Evolving Baseline 

     C. Viewing Baseline Plan / Usage 

5. SQL Profile + Lab 

     A. Generated by SQL tuning advisor 

     B. Transport to another DB 

6. SQL Patch + Lab 

     A. Grabbing a SQL ID 

     B. Adding a patch (hint)

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 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

 

Maximize Oracle Database Appliance Benefits using KVM

Maximize Oracle Database Appliance Benefits using KVM

Session Abstract: The Oracle Database Appliance (ODA) saves time and money by simplifying deployment, maintenance, and support of database solutions for organizations of every size. Optimized for the world's most popular database--Oracle Database--it integrates software, compute, storage, and network resources to deliver database services for a wide range of custom and packaged online transaction processing (OLTP), in-memory database, and data warehousing applications. ODA release 19.9 introduced full ODA tooling support for KVM. KVM-based virtualization complements ODA’s pay-as-you-grow (core licensing) feature and enables rapid deployment of applications in KVM, resulting in a “Solution-in-a-Box”. This Webinar will introduce ODA and show how to make the most of this optimized and yet easy-to-use platform using KVM virtualization.
Samarjeet Tomar
Director of Software Development, Oracle

 

Samarjeet Tomar is a Director of Software Development in the Oracle Database Appliance (ODA) product development group at Oracle. Samarjeet’s team develops the technology that makes ODA a simple, optimized, and affordable solution for all database workloads. His past experience at Oracle includes development and management roles in the Automatic Storage Management (ASM) and ASM Cluster File System (ACFS) areas.

[Online] Conceitos Básicos de Cloud Computing e do Azure + Certificação AZ-900

Confira neste evento ONLINE e GRATUITO do canal Coding Night a terceira parte de uma série cobrindo conceitos básicos de cloud computing, uma visão geral do Microsoft Azure, além de dicas para você que pretende realizar o exame de certificação AZ-900 - Microsoft Azure Fundamentals.

Saiba como se beneficiar da computação em nuvem, conhecendo ainda diferentes opções disponibilizadas pelo Microsoft Azure e se preparando para uma certificação. Tudo isso sem custo algum!

Quando: 26/02/2021 (sexta) a partir das 21:00 – horário de Brasília

Não assistiu as 2 primeiras partes? A gravação está disponível no YouTube:

* Parte 1: https://www.youtube.com/watch?v=zpMnl5owygg

* Parte 2: https://www.youtube.com/watch?v=IaAJigwUK5Q

Não deixe de acompanhar! Convide amigas, amigos e colegas de trabalho!

Ainda não segue o Coding Night nas redes sociais? Faça sua inscrição então, para ficar por dentro de novidades sobre eventos, tecnologias Microsoft e outros conteúdos gratuitos:

– Facebook: https://www.facebook.com/codingnightbr/
– YouTube: https://www.youtube.com/codingnight

Oracle Linux and Virtualization Tux Tech Talks

5 passos simples para migrar de RHEL e CentOS para Oracle Linux

Com frequência somos questionados pelos clientes como migrar de CentOS para Oracle Linux, em particular para cargas de trabalho críticas onde suporte empresarial é relevante. Oracle Linux possui 100% de compatibilidade binária com RHEL, portanto uma simples troca é o suficiente. Participe deste webinar para saber como fazer a migração em cinco passos simples.
Apresentador
Marcos Sungaila
Marcos Sungaila
Master Principal Sales Consultant, Oracle

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.

OATUG Mentor Program

Oracle Applications & Technology Users Group

Looking to expand your career, connect with people, and get to know more of OATUG's community? Join us for this session focused on the Emerging Leaders Mentor Program!

This webinar will introduce you to some of the OATUG Emerging Leaders and help you to learn about our Mentor Program. The Mentor Program connects early to mid-career professionals working in Oracle Applications and Technology with a mentor that can help guide them in their career.

You can learn a little about the Mentor Program here, but please feel free to bring any and all questions to 
this webinar.

Extreme Scalability and Enhanced Resilience for Oracle Integration

Learn how Oracle Integration can scale to support the most demanding applications and discover what the future holds for performance and scalability in OIC. We will discuss a customer who reached 1m messages an hour and talk about how future enhancements will allow even higher throughput. We will also discuss how to meet business continuance requirements by using a customer managed DR solution and talk about existing high availability in 
OIC.

Speaker: Antony Reynolds
Schedule: Tuesday February 23rd 16:30 – 17:30 CET (Berlin time)


For details please visit the registration page:

https://go.oracle.com/LP=106074?src1=:em:lw:ie:pt::SEV400125288&elq_mid=183787&sh=1762292022131692288158932126&cmid=ACMK210115P00023

Oracle Autonomous Database Cloud Workshop

Highlights
Dear Valued Partner,
We would like to invite you to our event “Oracle Autonomous Database Cloud Workshop” on the 23rd February 2021.
Discover how Oracle Autonomous Database Cloud (ADW / ATP) is changing the industry. Using AI and machine learning, its self-driving, self-tuning, and self-repairing capabilities encapsulates the sophisticated functionality of the Oracle Database into a fully managed data warehouse & Transaction Processing in the cloud. You can gain better insights faster and easier, making this the ideal choice for business big and small. With just a few clicks, you can easily provision the ADWC and run queries immediately.  And if your workloads grow, simply scale up your ADWC, and within seconds, you have more power to run your workloads with zero down time.
Agenda:
  • Overview of ADWC
  • Provisioning and Connectivity
  • Data Movement and Access
  • Scaling, Monitoring, and Management
  • Advanced Data Movement
Audience:
Database Administrators, Developers, Data Scientists, Application Administrators.
Pre-requisites:
  • Workshop attendees bring their own laptop
  • Hardware requirements:
o  Laptop: at least 8GB RAM and 40GB HardDrive
  • Software requirements:
oPutty for Windows
oWindows or Linux
Registration information

Event fee

No fee for active Oracle PartnerNetwork (OPN) Members.

Join Oracle’s Global Partner Enablement LinkedIn Group to find Oracle Partner enablement resources that will help you grow your business and deliver customer success.

Registration: This event is restricted to active OPN Members. When registering, you will be asked to login using an Oracle single sign-on account that is registered to an active OPN Company ID. If you do not have an Oracle account that has been registered to your OPN Company ID, please create / setup your account from Oracle Partner Store. Note: Only business email addresses are accepted for event registration.

ODTUG EPM Community Webinar: Inter-pod Revolutions: Connected Enterprise Solution in Oracle EPM Cloud

Presented by:Vatsal Gaonkar,Alithya

*This webinar is eligible for one (1) CPE credit for Computer Software & Apps. To receive the credit attendees must be a Full (paid) ODTUG member, attend the entire webinar and answer all poll questions that will pop up on-screen during the webinar, and fill out the evaluation form (with your name) that will pop up on your screen immediately after the webinar.

Prerequisites: None Program Level: Beginner to Intermediate Instructional Delivery Method: Group Internet Based Price & cancellation policy: Free. No need to cancel - if you do not attend you will be automatically cancelled.

At the time of this abstract submission, inter-application data transfer solutions are not possible using inter-pod data maps. The session will discuss a library of solutions implemented at clients for transferring between applications in separate pods. Each configuration has its own merits and use case. The four main categories that will be discussed are - 

   1.Trickle Feed - uses a combination of inter-pod REST API connection, data management load rule, groovy scripting and scheduled EPM Automate job on a jump server to pick-up the files from source and push to target. 

   2.Focused On-save Push - pushes an intersection from source to target using inter-pod REST API connection, data management load rule and groovy scripting. 

   3.Scheduled Push- uses a combination of windows or linux job, inter-pod REST API connection, groovy 
scripting, data management load rule and EPM Automate commands to extract and push data en masse from source 
to target. 

   4.Json Extract and Load - uses a combination of groovy scripting and inter-pod REST API connection to 
extract and push an intersection on-save. 

The audience will walk-away with learnings and understanding of inter-pod configurations, mainly for EPM Cloud planning applications. Snippets of code will form the "gold dust" takeaway from the session.