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…

Oracle Server, the flagship database, has many features familiar to Oracle DBAs for daily operation of solid production environments. These same DBAs are now expected to manage Oracle's MySQL that is being adopted by many companies. We explore the full life cycle and tools of a robust commercial MySQL environment, from development through production, as…

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…

Oracle Database 11gR2 has a number of unique features thataid in detecting and solving database and SQL related performance issues. AlthoughOracle 11g provide a plethora of tools and options to deal with databaseperformance, the question, however, is which of these are the most useful andpractical and how we can manage all the performance statistics that…