The market is flooded with tools touting their abilities to assist with establishing and maintaining an enterprise MDM repository and framework. But most of these tools are Customer or Product data centric. Modern day enterprises depend on more than just Customer and Product data to run and grow the business. Holistic Enterprise Data Management and…

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…

WikiLeaks has dramatically changed how organizations deal with data security. Without getting into the politics, this session will discuss how to mitigate data breaches in your APEX applications. It will follow your data through its “chain of custody”, and provide insights on securing it at each step. It will cover not only things to do…

Oracle announced several appliances and engineered systems - Database Appliance, Exadata, Exalogic, T4 super cluster, Exalytics and Big Data Appliance. While these products provided much needed gap in many cases, there is a tremendous amount of confusion about the proper usecase of these machines. In this session attendees will learn the difference between these, the…

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

Real Application Testing (RAT) with Database Replay and SQL Performance Analyzer has given us the ability to be more proactive in ensuring that application, database, operating system, hardware, etc. changes and upgrades never negatively impact our database and system operations again. This presentation will review the features and use of real application testing with Test…

IPM 11g is on a completely different architecture!! If you have been using IPM for some time, and now that it is time to upgrade have been told there isn't a clear path to make the upgrade, you need to attend this session. Learn from those that have done this before, and were successful. You…

This talk will provide tips for using SQL against an Oracle Database. It will discuss how to exploit a selection of lesser known features and also how to avoid traps and pitfalls. Examples of redundant and undocumented functions, such as OVERLAPS, REVERSE and the range of SYS_OP functions will be covered and some of the…

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…