Oracle GoldenGate has been widely used as a data replication and integration technology. At PayPal, Inc., there are many large scale Oracle GoldenGate systems implemented to support data replication/integration needs. This session will overview Oracle GoldenGate architecture and common use cases, new features offered by the latest GoldenGate v11 release, best practice in managing/scaling 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…

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…

This is a two-part session that will take place on Tuesday and Wednesday. “I never had the need for Analytic Functions”, is one of the phrases that is heard quite often. Maybe that’s true, maybe it isn’t. Recognizing the need for a particular feature can only occur when you have enough exposure to the feature.…

This is a two-part session that will take place on Tuesday and Wednesday. “I never had the need for Analytic Functions”, is one of the phrases that is heard quite often. Maybe that’s true, maybe it isn’t. Recognizing the need for a particular feature can only occur when you have enough exposure to the feature.…

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…

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…

This presentation is based on real world example of a complex migration and consolidation. 21 databases, 15 tb in size, with 200,000 objects were merged into one database. Consolidation of multiple databases into a single database has several unique advantages including but not limited to … improved operations and management, simplified backup and recovery, easy…

This presentation is based on real world example of a complex migration and consolidation. 21 databases, 15 tb in size, with 200,000 objects were merged into one database. Consolidation of multiple databases into a single database has several unique advantages including but not limited to … improved operations and management, simplified backup and recovery, easy…

It's fun discovering new performance ideas. Have you ever been surprised by the simplicity of a performance technique? How did you miss that technique? That's where this presentation comes in. Drawing on his extensive background of solving 7,000 performance issues, Oracle ACE Chris Lawson presents ten surprisingly powerful performance tuning tactics. Some techniques are very…