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)
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 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
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 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.
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:
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.
Master Principal Sales Consultant, Oracle
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 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.
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.
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
- Overview of ADWC
- Provisioning and Connectivity
- Data Movement and Access
- Scaling, Monitoring, and Management
- Advanced Data Movement
- Workshop attendees bring their own laptop
- Hardware requirements:
- Software requirements:
No fee for active Oracle PartnerNetwork (OPN) Members.
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.
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.