Oracle Enterprise Manager is more than a database management tool. It allows the administrator to monitor or manage the entire application stack, from the physical servers, to the storage arrays up to the operating system and into the middleware and database. You can also monitor your Engineered systems with OEM, allowing for a single view…

This talk will benefit the beginner Oracle DBA when faced with running Oracle on a Windows Server, and may also teach some old hands a trick or two.  Instead of delving into topics that would be for Server Administrators, this session will deal with issues directly related to running Oracle on a Windows box. Learning…

The Oracle RDBMS is highly tuneable with many options for optimizing performance. However, the sheer quantity of tuning options can be overwhelming, and you can waste precious time unless you know which tuning activities are most likely to provide a return on your time investment.  In this presentation we’ll review ten of the fundamental Oracle…

Oracle Database 12c introduced many new features, including Oracle Multitenant and memory optimizations for greater consolidation density and faster performance. This session discusses the key new features that can help maximize database performance, enable smart capacity planning, improve data security, and provide the basis for smart and effective database administration.

Learn about ASH Masters a github repository of queries against Average Active Sessions (ASH). Learn about ASH math, average active sessions and the power and pitfalls of ASH queries. ASH queries will be shown that display over database performance from on high to diving deep down into the nitty gritty of performance bottleneck's internal workings. Active…

The promise of cloud computing—greater agility, less risk, and lower costs—is real, but realizing that promise depends on the approach one adopts. Various cloud vendors offer choice and flexibility with the most comprehensive, modern, and secure portfolio of cloud products and services to meet the business needs and deliver the full benefits of cloud computing.…

Your ASH repository is a veritable gold mine of performance information and while the GUI interface in OEM is very pretty and easy to use, it has its limitations.  In this session, I'll be showing several examples of how sifting thru the ASH data directly via SQL can shed new light on some common problems.…

Learn how to effectively use the tool many call the best tool ever created by Oracle to tune and troubleshoot SQL on Oracle databases - the real time SQL Monitor. A new real time SQL execution tuning and troubleshooting tool called SQL Monitor was introduced in 11g and has been enhance for 12c. Many call…

Imagine a world where a Database Administrator could simply order a new database and in less than 1 hour an e-mail arrived confirming it had been completed.  What about adding additional storage or adjusting the amount of memory or CPU, for an existing database, simply from a web page.  EMC IT built a private cloud…

This presentation will cover implementation of OEM 12c in an existing OEM 11g managed database environment.   The presentation will be a case study on moving from a basic OEM 11g implementation to a more advanced highly available  OEM 12 installation.   A dual self monitoring OMS installation with a load web application front end and Oracle…