OracleDatabase10gTheSelf-ManagingDatabase.pptVIP

Oracle Database 10gThe Self-Managing Database Benoit Dageville Oracle Corporation benoit.dageville@ Agenda Oracle10g: Oracle’s first generation of self-managing database Oracle’s Approach to Self-managing Oracle10g Manageability Foundation Automatic Database Diagnostic Monitor (ADDM) Self-managing Components Conclusion and Future Directions Oracle10g Oracle10g Oracle10g is the latest version of the Oracle DBMS, released early 2004 One of the main focus of that release was self-management Effort initiated in Oracle9i Our vision when we started this venture four years ago: make Oracle fully self-manageable We believe Oracle10g is a giant step toward this goal Oracle’sApproach Oracle’s Approach: Server Resident Technology built inside the database server Eliminate management problems rather than “hiding” them behind a tool Minimize Performance Impact Act “Just in Time” (e.g. push versus pull) Leverage existing technology Effective solutions require complete integration with various server components server becoming so sophisticated that a tool based solution can no longer be truly effective Mandatory if the end-goal is to build a truly self-managing database server Oracle’s Approach: Seamless GUI Integration Oracle’s Approach: Holistic Avoid a collection of point solutions Instead, build a comprehensive solution Core manageability infrastructure Comprehensive statistics component Workload Repository Server based alerts Advisory framework Central self-diagnostic engine built into core database (Automatic Database Diagnostic Monitor or ADDM) Self-managing Components Auto Memory Management, Automatic SQL Tuning, Automatic Storage Management, Access Advisor, Auto Undo Retention, Space Alerts, Flashback…. Follow the self-managing loop: Observe, Diagnose, Resolve Oracle’s Approach: Out-of-box Manageability features are enabled by default Features must be very robust Minimal performance impact Outperform manual solution Self-managing solution has to be self-manageab