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.…

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…

Having to bring a someone with a different technology background up to speed with Oracle is something many DBAs have had to deal with at some point or will have to deal with at some point in their professional lives. But when it is all said and done, what does the person who had to…

IT organizations today have to support multiple mobile devices, such as iPhones, iPads, BlackBerry smartphones, and many other tablets and mobile devices. Mobilizing enterprise applications and data across these platforms traditionally requires major investments and duplication of development efforts and dramatically lowers the ROI of the mobile application initiative. This session demonstrates how Oracle JDeveloper…

Have you ever experienced an unexpected rush of users on the system which almost ground it to a halt? Have you ever had to approach management with a request for more resources due to poor performance in tight budget times? This presentation will discuss how to potentially avoid these situations in advance though load testing.…

Have you ever experienced an unexpected rush of users on the system which almost ground it to a halt? Have you ever had to approach management with a request for more resources due to poor performance in tight budget times? This presentation will discuss how to potentially avoid these situations in advance though load testing.…

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…