Weekly Events #5

Here is a summary of the EVENTS for this and next week!

 

APRIL 11

 

Oracle Systems Advantage Forum

DATA DRIVEN INFRASTRUCTURE FOR THE FUTURE ENTERPRISE

Is your it infrastructure built to enable a data-driven future enterprise?

We invite you to join us and experience this on 8th April as Oracle Systems Advantage Forum goes live virtually in association with Intel.

READ MORE

 

   APRIL 12

 

JD Edwards INFOCUS Envision 2021
Plan ahead: roadmaps, product updates, enhancements, cloud adoption and more.
   APRIL 13

 

Oracle Cloud Infrastructure (OCI) Advanced Workshop

Certification Readiness Training for Oracle Cloud Infrastructure 2020 Architect Professional

Oracle set an ambitious goal in building its second-generation cloud infrastructure: to create an infrastructure that matches and surpasses the performance, control and governance of enterprise datacenters, while delivering the scale, elasticity, and cost-savings of public clouds. The result, Oracle Cloud Infrastructure, is built from the ground up to be an Enterprise Cloud, equally capable of running traditional multi-tiered enterprise applications, high-performance workloads, and modern server less and container-based architectures.

READ MORE

 

Oracle Cloud Infrastructure Professional Certification Training Class

Join us at our Oracle Cloud Infrastructure (OCI) Partner Certified Architect Professional Training event to learn the latest in OCI technical features. This event will not only help you enrich your knowledge in deep technical features of OCI, but will also allow a unique chance to hear from the OCI Product Management & Engineering staff that’s pioneering the next generation of cloud at Oracle.

READ MORE

 

Oracle Cloud Infrastructure Advanced 200 Workshop

Oracle set an ambitious goal in building its second-generation cloud infrastructure: to create an infrastructure that matches and surpasses the performance, control and governance of enterprise datacenters, while delivering the scale, elasticity, and cost-savings of public clouds. The result, Oracle Cloud Infrastructure, is built from the ground up to be an Enterprise Cloud, equally capable of running traditional multi-tiered enterprise applications, high-performance workloads, and modern server less and container-based architectures.

READ MORE

 

Protect Yourself Against Database Downtime with Oracle

Emerging cloud technologies are transforming businesses today. Join us at our webinar on Tuesday, 13 April 2021 @ 10:00 a.m. GMT+2, where you will hear how the Oracle Database Appliance 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.

READ MORE

 

GitOps keeps focus on product, not on infrastructure – Jakarta Tech Talks

Development teams spend time on a lot of things other than their product. They manage infrastructure, DevOps and integrations, and even create staging servers so that an external agency can test out your sweet new redesign. Maybe it’s not even just one site to worry about, but a whole fleet of applications that need to be kept in-sync, secure, and up-to-date, all while sticking to a release schedule.

No one has that much attention or experience to manage it all, and it’s a lot to ask of them to keep up with.

READ MORE

 

How Oracle Builds Internet Scale Applications with Oracle Database on Oracle Cloud Infrastructure

Learn how Oracle uses sharding in Oracle Cloud Infrastructure to achieve extreme scalability, availability, and performance benefits.

  • Extreme scalability with petabytes of data with no impact on latency;
  • Performance improvements when compared to other key value stores;
  • Improved latency over NoSQL implementation.

READ MORE

 

Optimize Cost & Increase Value with Database Cloud Services

Oracle has created a second generation cloud platform with security, performance and reliability at its core. Oracle Cloud Infrastructure is built for enterprises looking for higher performance, lower costs and easier cloud migration from their on-premise applications. Customers who are using OCI get exclusive access to Oracle Autonomous Database and a whole range of Database Services that can be adapted to any use cases and any modern workload that exists today.

READ MORE

 

GUOB Webinar: PLSQL Development Best Practices for DBAs

Dev PL/SQL? Nesta sessão veremos alguns truques e ferramentas que podem mudar a sua vida. Pra melhor! 🙂

Onde: https://www.youtube.com/c/GUOBOficial
Realização: GUOB
Palestrante: Matheus Boesing

READ MORE

   APRIL 14

 

Oracle Exadata/ExaCC Nordic User Group Meeting

Join us at our virtual oracle exadata/exacc user group meeting on 14th april 2021.

The aim of the conference is to foster open discussions and peer-to-peer knowledge sharing about best practices, tips & tricks to make private cloud deployments even simpler with Oracle Exadata Database platform and Exadata Cloud@Customer.

The program includes a keynote presentation by Dario Wiser, EMEA Business Development Director – Cloud Systems who will share the Exadata Roadmap and some exciting technology advances.

READ MORE

 

Oracle Cloud Infrastructure Advanced 200

Oracle Cloud Infrastructure est un ensemble de services cloud qui vous permettent de créer et d’exécuter une large gamme d’applications. Oracle Cloud Infrastructure combine la souplesse et l’utilité du Cloud public avec un fort niveau de contrôle, de sécurité, et une très haute disponibilité et prévisibilité de l’infrastructure on-premise, pour fournir des services d’infrastructure rentables et de hautes performances.

Oracle Cloud Infrastructure est la première plate-forme Cloud à mettre en œuvre la virtualisation de réseau off-box, qui sort la virtualisation du réseau et des ressources de la stack logicielle pour la placer dans la couche réseau.

READ MORE

 

Oracle Database Appliance High Availability and Disaster Recovery

Oracle Database Appliance è la soluzione semplice, ottimizzata e conveniente per tutti i tipi di carichi di lavoro del database. In ogni caso, la semplicità non ha bisogno di scendere a compromessi con l’affidabilità. Oracle Database Appliance semplifica le operazioni di distribuzione di tutte le funzionalità di alta affidabilità del database, inclusi Oracle Real Application Clusters e Oracle Active Data Guard, adattandosi alle best practice raccomandate da Oracle. Unisciti ad una sessione della durata di un’ora in cui potrai approfondire come Oracle Database Appliance può semplificare le tue soluzioni di alta affidabilità e disaster recovery.

READ MORE

 

Oracle State and Local Government Virtual Cloud Summit

MASTER YOUR CLOUD STRATEGY. LEARN FROM YOUR PEERS HOW TO BEGIN YOUR JOURNEY TO THE CLOUD

Many government agencies are seeking advice about how to begin their migration to cloud. Join a panel of your colleagues from across the country who have successfully moved to Oracle Cloud Infrastructure.

READ MORE

 

Oracle Converged Database

INNOVATOR’S DILEMMA: CONQUERING THE COMPLEXITY OF MODERN APPDEV

Developing modern, powerful, reliable applications without losing your mind.

Once upon a time, not so long ago, AppDev for business purposes was relatively simple. A small team of developers would use a single development tool and database to quickly develop a new app for the business. That time is gone. Modern AppDev has become dramatically more complicated with the increased adoption of state-of-the-art Data-Driven technologies such as Machine Learning, Graph Analytics, Spatial Processing, and Blockchain to help gain better insight into customer’s needs.

READ MORE

 

A Tour of the Oracle Database block

Session Abstract: A look inside an Oracle block, the fundamental unit of the Oracle Database. We’ll see how a block is constructed, and how the components inside the block are used by the database to provide performance and concurrency. Unlike a typical internals deep-dive, this session will be more focused on how this internals related back to real-world use cases, such as how queries work, storage optimization, and application locking.

READ MORE

 

   APRIL 15

 

Architectural Principles and Best Practices for Adopting Oracle Cloud
We would like to invite you to attend a webinar Advantage Moving Oracle Database to Oracle Cloud held on April 15 at 09:00-10:00 CET.
Data is considered the most valuable asset of a company. But it’s not just about storing it, you need to extract value out of it.
If your DBA team spends most of its time managing the infrastructure and less time on the data itself, you need a more agile Data Management solution.
Oracle Cloud has the most complete, secure and innovative Data Management Platform. Through automation, scalability and performance, Oracle Cloud takes care of your data, allowing you to focus on your business.

READ MORE

 

Before Disaster Strikes Architect Seminar Series

Achieving resiliency in your business continuity strategy. 

Oracle invites you to a virtual seminar and panel discussion focused on mitigating risks in the uncertain times we live in today.

Natural disasters, system failures, operator error, and malicious hackers are causing serious damage to organizations without a well-planned high availability and disaster recovery strategy. Those consequences include lost revenue, diminished customer satisfaction, regulatory fines, lost data, and ransomware payments to name a few. Learn how BIAS, a leading IT solutions provider and award-winning Oracle partner, has designed and implemented high availability, disaster recovery and security strategies for some of the world’s leading companies leveraging Oracle technologies.

READ MORE

 

Diving into Oracle Cloud Infrastructure – Hands-on workshop

With an array of benefits Oracle Cloud Infrastructure is pushing boundaries and exceeding expectations in the Cloud world. Companies like Zoom, BotSupply and CERN have already moved key workloads to the Oracle Cloud.

Join the hands-on-workshop to hear and test first-hand how OCI leads to better performance, higher security while maintaining low costs – and the ease of cloud migration.

READ MORE

 

Live Developer Webcast

TRANSFORM YOUR WLS JAVA APPS TO MICROSERVICES ON ORACLE CLOUD INFRASTRUCTURE WITH VFUNCTION.

Legacy Java applications are difficult to modernize. Enterprises rely on these monolithic apps to power their businesses but face an urgent mandate to move to the cloud and adopt a cloud native architecture.

READ MORE

 

Cloud Computing SIG April Meeting

Join us for our monthly Cloud Computing SIG meeting!

READ MORE

 

   APRIL 16
Architectural Principles and Best Practices for Adopting Oracle Cloud
We would like to invite you to attend a webinar Advantage Moving Oracle Database to Oracle Cloud held on April 15 at 09:00-10:00 CET.
Data is considered the most valuable asset of a company. But it’s not just about storing it, you need to extract value out of it.
If your DBA team spends most of its time managing the infrastructure and less time on the data itself, you need a more agile Data Management solution.
Oracle Cloud has the most complete, secure and innovative Data Management Platform. Through automation, scalability and performance, Oracle Cloud takes care of your data, allowing you to focus on your business.

READ MORE

 

Before Disaster Strikes Architect Seminar Series

Natural disasters, system failures, operator error, and malicious hackers are causing serious damage to organizations without a well-planned high availability and disaster recovery strategy. Those consequences include lost revenue, diminished customer satisfaction, regulatory fines, lost data, and ransomware payments to name a few. Learn how BIAS, a leading IT solutions provider and award-winning Oracle partner, has designed and implemented high availability, disaster recovery and security strategies for some of the world’s leading companies leveraging Oracle technologies.

READ MORE

 

Getting started with Oracle Machine Learning – Hands-on Workshop

No experience with Oracle Analytics Cloud (OAC) yet? During this workshop you will get started with the integrated Machine Learning functionalities of Oracle’s most innovative Analytics Platform. Learn how to make use of Augmented Analytics and talk to your data in able to quickly gain insight and easily discover hidden patterns and trends. How do you train a ML model and how do you apply it to make a prediction. These are two examples of what you will find out during this Machine Learning hands-on workshop. You don’t need any Machine Learning prior knowledge!

READ MORE

 

OCI Database Management Cloud Service

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.

READ MORE

VPD: “row cache objects” latch contention

The other day, we found high occurrence of latch events in our principal/core environment (11.2.0.3.0). The origins are all “different businesses channels” that access objects through the use of VPD. The latch events was bit by bit dominating the environment during the last months and turn on an “attention alarm” to us.

Then we found the the note: Bug 12772404 – Significant “row cache objects” latch contention when using VPD – superseded (Doc ID 12772404.8).

The situation is right the same:

“When VPD is used, intense row cache objects latch contention (dc_users) may caused by an internal Exempt Access Policy privilege check. Rediscovery Information: 
VPD is in use 
Significant “latch: row cache objects” waits occur
The waits are for the latch covering dc_users”

Take a look on the DC_USERS latches:
dc_users

And about the workaround:
“There is no direct workaround available.
The following guidelines may help to alleviate the problem :
– Dropping the database roles from our user:
The Number of Roles granted to user can increase the row cache
look-ups proportionally. When database is required to check whether
a system privilege is granted to User, it checks if that privilege
is granted to any of the User’s roles. Hence, it’s not helpful
to do something like “set role A, B, C, D, F …” to recreate its
environment for every execution.
– Changing the policy function might be helpful in some cases
eg: To use CONTEXT dependent policies instead of DYNAMIC policies”

Take a look in one of the examples of:

boesing@mydb4> /
P1RAW EVENT USERNAME SQL_ID SQL_CHILD_NUMBER LAST_CALL_ET SID SEQ# WAIT_TIME SECOND
--------- ---------------- ------ ------ ---------- ---------- ------
0700011807B50D08 latch: row cache objects CHANNELAPP 4nwvpx8xt3h3m 22 0 1276 59113 0
0700011807B50D08 latch: row cache objects CHANNELAPP fp3mft3usb74w 0 21719 16636 0
0700011807B50D08 latch: row cache objects CHANNELAPP 58pund2p09hgg 0 6774 11061 0
0700011807B50D08 latch: row cache objects OTHER_CHANNELAPP 54a2wfa60rgu1 1 0 8046 12386 0
0700011807B50D08 latch: row cache objects CHANNELAPP 1gwr69wduk9v4 42 0 9454 53927 0
0700011807B50D08 latch: row cache objects OTHER_CHANNELAPP 9pqrqqfzukrq4 68 0 9732 19311 0
0700011807B50D08 latch: row cache objects CHANNELAPP d1bnq8wb0nhrf 0 1 11425 56830 -1
0700011807B50D08 latch: row cache objects CHANNELAPP 32aqdd8cbmc4b 0 11711 39182 0
0700011807B50D08 latch: row cache objects IB_RUN adgnrpwazbfmz 0 12133 3372 0
0700011807B50D08 latch: row cache objects IB_RUN cqmgxvb78q9hy 0 17913 6345 0
0700011807B50D08 latch: row cache objects CHANNELAPP byzm159jbjxaa 0 6 19606 52624 0
0700011807B50D08 latch: row cache objects OTHER_CHANNELAPP 2kbjztd9yzqfm 61 0 20732 28687 0
0700011807B50D08 latch: row cache objects CHANNELAPP 6dvagdabts9nx 19 7 21011 504 0
0700011807B50D08 latch: row cache objects CHANNELAPP 9pqrqqfzukrq4 78 0 21439 19030 0
0700011807B50D08 latch: row cache objects CHANNELAPP gq1avu79h2np3 85 0 3815 33831 -1
boesing@mydb4>SELECT child# FROM v$latch_children WHERE addr= '0700011807B50D08';
CHILD#
----------
8
boesing@mydb4> select s.kqrstcln latch#, s.kqrstcid cache#, kqrsttxt name from x$kqrst s where s.kqrstcln=8;
LATCH# CACHE# NAME
---------- ---------- --------------------------------
8 10 dc_users
8 7 dc_users
8 7 dc_users
8 7 dc_users

The problem was definitively solved by applying the 11.2.0.4.2 PSU. No problems after that.
Good luck, if it’s your situation.

Hugs!
Matheus.