Are you paying your top Oracle DBA’s to reset passwords and perform user management? Typical Oracle database shops have numerous databases for their different applications. Without a centralized user management solution, this forces the DBA’s to burn cycles on user management tasks to ensure users have the proper access. Implementing Enterprise User Security will rid…

A database cloud is a model for enabling convenient, on-demand access to a shared pool of configurable computing resources. These resources can include servers, storage, applications, and services, which can be rapidly provisioned and released with minimal management effort. Oracle Real Application Clusters (RAC) provides the required functionality to enable such a database cloud. You…

This session will describe user experiences with tuning the set up for an Oracle Database running on Linux on IBM System z. It will cover the options in z/VM, Linux, Storage, and init.ora that can improve the throughtput achieved.

This session will cover several recent experiences of setting up the the Linux on z environements for Oracle DB 11gR2 with the latest versions of the RedHat and SLES distributions to prepare for the Oracle installation.

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…