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.

Enterprise Portals present sensitive information and processes, which makes it imperative that these Portals be completely secure. Oracle WebCenter Security Framework provides advanced Role-based Access Control without sacrificing the flexibility that your Portal users need. Come and attend this session to learn how WebCenter Portal provides key integrations with Oracle Middleware including Oracle Entitlement Server…

Exadata is an engineered system that has a variety of expansion options. Learn about the methodology that was used to determine the expansion approach and the lessons learned with expantion of an Exadata system with the Exadata Storage Expansion.

This is a two-part session that will take place on Monday and Tuesday. The database landscape is evolving as new, scalable data stores emerge. Key value stores, large tabular stores, and document-oriented databases offer a compelling alternative to the traditional relational database. By removing joins and loosening ACID constraints, this new class of non-relational or…

More and more companies are utilizing virtualization in their environments to lower costs and effectively utilize resources. Placing Oracle databases in virtualized environments is not just for development and testing anymore. The rise of virtualization is introducing new performance challenges to the Oracle DBA that are not well documented at this time and these issues…

In this session, see how Medtronic’s iPad-based mobile content management system allows sales reps to quickly access the latest product videos, presentations, and PDFs on-the-go, while storing the information centrally and securely in Oracle WebCenter Content. By leveraging Fishbowl’s iOS Mobility Suite API, sales reps can access collateral from WebCenter within an easy-to-use iPad application.…

Even the best-planned database upgrades can leave nagging questions: what happens if my upgraded system performs unexpectedly? Is there a way I can go back to the previous version without downtime and data loss? Oracle GoldenGate allows DBAs to give affirmative answers to these questions. Drawing on upgrade experiences ranging from mid-sized databases to a…

Attend this session to get the inside track on how Oracle Exadata is monitored and managed using Oracle Enterprise Manager. Learn from a real-world implementation on how to effectively instrument and monitor your engineered systems.

In special situations, the Oracle Database generates too many child cursors for particular SQL-IDs. This results in high CPU load on the DB server, coming from heavy mutex access. This is visible as mutex wait events. The lecture will show how this situation arises, how the DBA can try to quick-fix it and how long-term…

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.