This is a two-part session that will take place on Monday and Tuesday. Database Replay, Online patching, Automatic memory management, SPA, ADR just to mention few of them have been associated more with Oracle11g new features. Oracle 11g has more to offer than the usual top 10 features. Most of us tired of the usual,…

Previous migrations of Oracle Enterprise Manager left a DBA with no fallback position and extensive outage periods for the actual upgrade. Oracle Enterprise Manager 12c has been completely rewritten that includes a comprehensive step-by-step method of safely upgrading including a pre-defined fallback method to revert to. Best practices on using the new Pre-Upgrade Console to…

The design of streams replication involves a pipeline of components that are responsible for capturing, propagating, and applying logical change records (LCRs) from a source database to a destination database. Because of the interaction between streams and the database, there are a number of areas that can suffer performance problems thus obstructing real-time data updates.…

This is a continuation of “Oracle11.1 to 11.2 – In giant steps” session. The previous session talked about what you need to think about before starting the migration. This session continues the process to discuss the specific steps needed to upgrade from Oracle11.1 to Oracle11gR2.

Cloud Computing and Virtualization have been a top priority for IT and Business in recent years. Besides analyst and media focus with very large forecasts, it is also seen as a disruptive way to do business with technologies. Part 1 of this presentation, focuses on Cloud Computing Core Concepts and introduces concepts in an easy-to-understand…

This is a two-part session that will take place on Monday and Tuesday. Database Replay, Online patching, Automatic memory management, SPA, ADR just to mention few of them have been associated more with Oracle11g new features. Oracle 11g has more to offer than the usual top 10 features. Most of us tired of the usual,…

The Automatic Workload Repository is a powerful feature that was introduced in Oracle 10g and improved in Oracle 11g. Learn how you can utilize that power at an Enterprise level by bringing your Automatic Workload Repository data together into a central repository to compare reports across databases in your Enterprise; keeping snapshot data for longer…

This is a two-part session that will take place on Monday and Tuesday. Database shrinking can be overwhelming. Don’t let this feature intimidate you; let it become a powerful friend! This session describes why shrinking is needed and just how to go about using it. Being forewarned and forearmed will decrease the learning curve and…

This is a two-part session that will take place on Monday and Tuesday. Database shrinking can be overwhelming. Don’t let this feature intimidate you; let it become a powerful friend! This session describes why shrinking is needed and just how to go about using it. Being forewarned and forearmed will decrease the learning curve and…

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…