During this presentation, a case study is unfolded to reveal the true cause of a slow performing query. Did the database just "have a bad day"? Was the evil DBA to blame? The PL/SQL developer who didn't get enough coffee? Or was it the application sending the "wrong" query in the first place? In this…

Set is a card game which is fun to play while exercising your mind. In this session you will learn about the SET game, as well as how you can leverage SQL to solve it really quickly. Learn advanced features of SQL, such as Subquery Factoring and ANSI join syntax while we're cheating in the…

Set is a card game which is fun to play while exercising your mind. In this session you will learn about the SET game, as well as how you can leverage SQL to solve it really quickly. Learn advanced features of SQL, such as Subquery Factoring and ANSI join syntax while we're cheating in the…

Transportable Tablespaces (TTS) are one of the most versatile features in Oracle Database. Leaving the datafiles in place with TTS are one of the fastest methods of upgrading without an additional option license cost. Several case studies will be covered: Archiving partitions, storage migrations, TSPITR and sharing a read-only tablespace between databases.

Do you truly know why you should be regularly applying Oracle Critical Patch Updates? This session will provide an in-depth look and demonstration of different types of security vulnerabilities fixed by Oracle’s quarterly Critical Patch Updates (CPU). Using information and exploit code that is published and readily available on the Internet, actual security bugs fixed…

Do you truly know why you should be regularly applying Oracle Critical Patch Updates? This session will provide an in-depth look and demonstration of different types of security vulnerabilities fixed by Oracle’s quarterly Critical Patch Updates (CPU). Using information and exploit code that is published and readily available on the Internet, actual security bugs fixed…

Learn from past successful experiences how to best conduct a Proof of Concept to put Oracle databases including 11gR2 and EBS on Linux on IBM System z. The session will discuss the key lessons learned when installing the 11gR2 Oracle Database on Linux on System z . Topics include how to set up z/VM Linux…

Transportable Tablespaces (TTS) are one of the most versatile features in Oracle Database. Leaving the datafiles in place with TTS are one of the fastest methods of upgrading without an additional option license cost. Several case studies will be covered: Archiving partitions, storage migrations, TSPITR and sharing a read-only tablespace between databases.

Transportable Tablespaces (TTS) are one of the most versatile features in Oracle Database. Leaving the datafiles in place with TTS are one of the fastest methods of upgrading without an additional option license cost. Several case studies will be covered: Archiving partitions, storage migrations, TSPITR and sharing a read-only tablespace between databases.

In this presentation, I will introduce concepts behind SCAN addresses, SCAN listeners, VIP addresses, VIP listeners, HAIP etc. I will also talk about how to integrate all these new features to setup the RAC environment optimally. It is important to understand the concepts behind these RAC features to effectively implement for high availability.