This is a two-part session that will take place on Tuesday and Wednesday. The new Oracle Enterprise Manager 12c offers a wealth of new technology including additional abilities for the database administration. Whether a new or seasoned DBA, attend this session for a best practice demonstration and jumpstart on how to use them and make…

RMAN is a must-have tool familiar to most Oracle DBAs. There are many capabilities hidden in RMAN and going beyond the basics is important. After a quick review of the core functionality, we will discuss both old and new features and provide tips and tricks along with sample code using the Command Line Interface (CLI).

Ever wondered how Oracle locks a row, or a table? Is there a master lock manager? No, there is not. In this session you will learn how Oracle manages the locking with demos, how ITL slots are used and how you can avoid the issues related to ITL slots. Also learn how unindexed Foreign Keys…

This paper has detailed coverage of real world lessons learnt in implementing SQL Plan Management to solve everyday performance issues related to SQL plan variability. SQL Plan management was used to baseline plans for 7 (seven) critical business processes at SEI, a Global Wealth Management service provider with strict SLA(s) tied to them. The results…

This session answers many questions around Oracle Resource Manager implementation based on a real implementation at SEI a Global Wealth management service provider. The crux of the problem that was solved at SEI was managing prioritization of workload specifically to leverage infrastucture there is always the possibility of fierce competition for resources when N number…

Program Global Area (PGA) resides in the process private memory of the server process. PGA_AGGREGATE_TARGET is used to control the sizing of workareas. Often improper setup and incomplete understanding of the inner working of PGA and the interconnectivity with OS settings leads to ORA-4030 errors, which are raised when memory or resources are requested from…

All DBAs know a thing or two about partitions. We know the various types of partitions, when we think we should use partitions, etc. However, most DBAs don't know the events that occur in the background when the various types of partitions are used. How do indexes behave when partitions are introduced? This session takes…

This presentation is a high-level introduction to Oracle RAC. Many RAC beginner presentations are given by seasoned RAC experts and contain an overwhelming suite of technical discussions, covering a way too much information for the level of expertise of most attendees. This presentation is given by a beginner with the RACand will introduce attendees to…

Come hear how CenturyLink (CTL) selected the Oracle Database Machine after evaluating multiple platforms to extend or re-platform its current multi-terabyte Oracle data warehouse. CTL is a telecommunications company created in 2009 when CenturyTel acquired EMBARQ. This merger exceeded the capacity of the current CTL data warehouse. To resolve this situation, CTL evaluated the HP…

There are many code debugging tools available to Oracle developers. Some require more effort than others. The author will walk the audience through a debugging session using SQL Developer 3.0.4 and how it's used with XML Documents. Examples will be shown using Oracle 11gR2