Data security is critical for a business. Data is not just providing the business processes, workflows and intelligence but are the assets for the company. Protection of the data in databases and in-transit is important if on-premise or in the cloud. They might even been traveling between the two. The skill is mitigating the risk…

Reducing work done by the database is key to improving performance in Oracle-intensive applications. The Server Result Cache allows applications to virtually eliminate work done when processing repeated queries. For applications dealing with growing data sets, this ability can be very beneficial. The presentation will begin by focusing on SQL Query Result Cache and PL/SQL…

Reducing work done by the database is key to improving performance in Oracle-intensive applications. The Server Result Cache allows applications to virtually eliminate work done when processing repeated queries. For applications dealing with growing data sets, this ability can be very beneficial. The presentation will begin by focusing on SQL Query Result Cache and PL/SQL…

A new database architecture called sharding was introduced in Oracle 12cR2 database for linear scalability and complete fault isolation for OLTP workloads. This Oracle sharding architecture partition horizontally partitions data across discrete Oracle Databases (shards). All shards collectively form a single logical database. Come to this session to learn this new architecture and the related…

A new database architecture called sharding was introduced in Oracle 12cR2 database for linear scalability and complete fault isolation for OLTP workloads. This Oracle sharding architecture partition horizontally partitions data across discrete Oracle Databases (shards). All shards collectively form a single logical database. Come to this session to learn this new architecture and the related…

Many DBAs and Architects think they understand Oracle database replication. But it is often only physical replication, as performed by Data Guard, rather than logical replication as done by GoldenGate, Streams and others. There are 3 fundamental principles that govern how these logical replication tools operate, centred on conversion, identification, and conflict handling of the…

  Transform your ability to quickly respond to the challenge of ensuring high performing DB’s. The key to this transformation is to expertly use the advisor framework which underlies tools such as ADDM, SQL Tuning Advisor, Segment Tuning.  These tools provide actionable advice to the DBA seeking to solve performance problems, but getting at this…

  Transform your ability to quickly respond to the challenge of ensuring high performing DB’s. The key to this transformation is to expertly use the advisor framework which underlies tools such as ADDM, SQL Tuning Advisor, Segment Tuning.  These tools provide actionable advice to the DBA seeking to solve performance problems, but getting at this…

Reducing work done by the database is key to improving performance in Oracle-intensive applications. The Server Result Cache allows applications to virtually eliminate work done when processing repeated queries. For applications dealing with growing data sets, this ability can be very beneficial. The presentation will begin by focusing on SQL Query Result Cache and PL/SQL…

  Use the innovative Dynamic Oracle Performance Analytics (DOPA) approach that relies on big data and advanced analytical techniques to analyze and improve Oracle Database performance. The approach discussed in this presentation is accessible and easy to use, but more importantly it represents a step-change paradigm shift away from traditional methods. Instead of relying on…