The MITRE Corporation is a not-for-profit organization chartered to work in the public interest. MITRE manages federally funded research and development centers (FFRDCs), partnering with government sponsors to support their critical operational missions. MITRE’s Records Management department needed to deploy a system to help manage physical content and electronic records not just for retention, but…

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.

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 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.

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…