Behind the scenes, Oracle APEX stores all types of different information about your applications and user access in metadata tables. This session will cover some of the wide and varied uses you can put that data to.

Managing complex Oracle database environments often presents many challenges to the database administrators in the area of database performance, backup and recovery, disaster recovery, data growth, and development and testing. This session introduces common technologies offered by many disk storage subsystems. It examines how DBAs can combine Oracle features such as Automatic Storage Management and…

Ksplice, now available as part of Oracle Linux, updates the Linux operating system (OS) kernel, while it is running, without a reboot or any interruption. Only Oracle Linux offers this unique capability, making it possible for you to keep up with important Linux updates without burdening your team with the operational cost and disruption of…

Managing complex Oracle database environments often presents many challenges to the database administrators in the area of database performance, backup and recovery, disaster recovery, data growth, and development and testing. This session introduces common technologies offered by many disk storage subsystems. It examines how DBAs can combine Oracle features such as Automatic Storage Management and…

The goal of this presentation is to go beyond the basic features of Oracle’s Automatic Workload Repository (AWR) and SQL Plan Management (SPM) to avoid plan regression and learn to use these tools with new techniques. You will see ways to combine the information stored historically in AWR with the capabilities available with SPM to…

Ksplice, now available as part of Oracle Linux, updates the Linux operating system (OS) kernel, while it is running, without a reboot or any interruption. Only Oracle Linux offers this unique capability, making it possible for you to keep up with important Linux updates without burdening your team with the operational cost and disruption of…

Oracle Real Application Testing is a very useful tool introduced in Oracle Database 11g and further enhanced in Oracle Database 11g Release 2. This presentation discusses how Oracle Real Application Testing works by going under the covers and derives a set of best practices based on real life experience with this tool

When you ask a MySQL DBA about security, they will usually tell you one or more of these three things: 1) strong MySQL passwords; 2) proper user@host grants and 3) SSL connectivity. However in reality MySQL is not deployed in an isolated secure room with no network access like the CIA computer room in the…

When you ask a MySQL DBA about security, they will usually tell you one or more of these three things: 1) strong MySQL passwords; 2) proper user@host grants and 3) SSL connectivity. However in reality MySQL is not deployed in an isolated secure room with no network access like the CIA computer room in the…

Understanding the ‘TRUE’ High Availability (HA) requirements for the systems is the most critical component in providing and configuring the desired HA for the application. Business and IT must have a common understanding regarding the cost associated with the expected HA. The associated cost and the ‘TRUE’ HA requirements primarily drive the solution architecture and…