Asia

SQL monitor reports have been around for a long time. They are extremely useful in diagnosing the performance of a single execution of a SQL statement. Next to AWR, ASH, and SQL-trace, they are a tool every performance engineer should be comfortable with. In this session, we will introduce you to active SQL monitor reports. We'll first explain when SQL monitor is available, how to generate them, and discuss the anatomy of a SQL monitor report. In the 2nd part of this session, we'll go through a few example SQL monitor reports, and show how to use them to find

Materialized Views are very useful to increase the performance of frequently executed queries. In many database applications, Materialized Views are accessed directly using SQL. However, the use of Query Rewrite is much more elegant and flexible: The optimizer decides independently whether a suitable Materialized View can be used to accelerate the query. The goal is to be able to improve the performance of different queries with the smallest possible number of Materialized Views. Query Rewrite offers excellent possibilities for this. Although Query Rewrite is available in Oracle databases for a long time, the feature is still unknown to many Oracle

This session will focus on using AWR reports to tune OLTP and DSS workloads running on Oracle Real Application Clusters (RAC) both on generic systems and Exadata. This includes hints and tips to focus on relevant sections of the AWR report to quickly understand the root cause of the problem. Further, we will review AWR reports of some interesting real-world performance issues reported by customers and the diagnostics involved in resolving them Speaker BIO: Anil Nair Sr Principal Product Manager (RAC), Oracle USA Anil Nair is the Product Manager for Oracle Real Application Clusters (RAC). Oracle RAC is a cluster

In this session, learn about the new capabilities in the just-released Oracle Enterprise Manager 13c Release 5 that allows Oracle Databases to be deployed in the cloud or on-premises and stop worrying about the operational risks and management of these databases. This session covers the exciting features of Oracle Enterprise Manager 13c Release 5 in the following key areas: - Hybrid Cloud Management: Fleet monitoring, management and data movement across the entire IT estate – on-premises and in the cloud including Exadata Cloud@Customer, Exadata Cloud Service, Oracle Dedicated Region Cloud@Customer, Autonomous Database, and Oracle Databases deployed elsewhere - Ops Automation:

Oracle Database provides the industry’s most comprehensive and flexible auditing capability. Effective audit policies let you monitor database activity with a negligible performance impact. In this session, you’ll learn how to create audit policies that are selective and targeted to your needs, avoiding the common pitfall of collecting unnecessary audit information that, in turn, impacts database performance, increases storage costs, and may make it more difficult to spot malicious activity. Angeline Dhanarani, Principal Product Manager for Database Auditing, will share key tips to capture relevant audit events, reduce false positives, and support quick and reliable threat detection – all without

- Learn some simple techniques to optimize the performance of your Oracle, RAC, and Exadata databases. - Learn how you can lower latency and reduce your DB IO. - Learn how these techniques can work on bare metal, VMs, and Kubernetes. - Warning, SQL explain plans and indexes may be involved. Speaker BIO: Douglas Hood Consulting Member of Technical Staff, Oracle Doug is a Consulting Member of Technical Staff at Oracle. Doug is an evangelist for Oracle TimesTen, Oracle NoSQL, and Oracle In-Memory. Doug is passionate about performance, high availability, and simplicity.