Database Administrators spend countless hours troubleshooting SQL statements that have taken upon a new life after a simple system or environment change. Oracle 11G SQL Performance Analyzer provides a solution to this never ending regressive statement issues. This new feature of Oracle 11G allows the database administrator to get a granular view of the impact to sql execution plans and statistics due to environment changes and the best part is that it completely automates the impact analysis process of extremely large SQL workloads

Oracle 11G introduces multiple new features around Real Application testing. This feature allows the database administrator to take control of the simulation of workload to test the impact of infrastructure and database level changes through the recreation of actual workloads.  Enterprises today face a daunting task and cost of retesting their entire application for every infrastructure or database change thats rolled out in the Organization. This feature is particularly helpful during OS, Oracle patch rollouts, conversion to RAC, movement to low cost grid computing hardware etc.

Problem Management focusses on being proactive to identify and avoid problems that may occur in the IT infrastructure. While Incident management processes are focussed on identifying failures and restoring the services, problem management tries to research and identify the root cause of an existing problems to avoid its re-ocurrence. Problem management also focusses on identifying issues proactively based on trend data available from the system management / service desk.