Oracle 10G Database - DBA

Oracle Database 10g:Managing the Self-Managing Database......Page 1 How DBAs Spend Their Time?......Page 2 How DBAs Spend Their Time?......Page 3 Software Installation......Page 4 Simplified Creation & Configuration......Page 5 Basic Parameters......Page 6 Simplified Upgrade......Page 7 Out-of-the-Box Database Control......Page 8 How DBAs Spend Their Time?......Page 9 Data Pump: What is it?......Page 10 Features: Performance!!......Page 11 Features: Checkpoint / Restart......Page 12 Features: Monitoring......Page 13 Features: Network Mode......Page 14 Features: Fine-Grained Object Selection......Page 15 New Clients – expdp / impdp......Page 16 New Clients – expdp / impdp......Page 17 Features: Other Cool Stuff.........Page 18 Large Internet Company2 Fact Tables: 16.2M rows, 2 Gb......Page 19 Keep in Mind:......Page 20 Original exp and imp......Page 21 How DBAs Spend Their Time?......Page 22 Database Management Challenges......Page 23 Solution: Self-Managing Database......Page 24 Common Manageability Infrastructure: Automatic Workload Repository......Page 25 Automatic Workload Repository......Page 26 Statistics Level......Page 27 Configuring The Workload Repository......Page 28 Manually Creating Snapshots......Page 29 Database Feature Usage Metric Collection......Page 30 Common Manageability Infrastructure:Server Alerts......Page 31 Server Alerts......Page 32 Server Alerts Delivery Process......Page 33 Server-Generated Alert Types......Page 34 Out-of-the-box Alerts......Page 35 EM Interface to Alerts......Page 36 Setting Alert Thresholds......Page 37 Common Manageability Infrastructure:Automated Tasks......Page 38 Automatic Optimizer Statistics Collection......Page 39 Gather Statistics Job......Page 40 Adding New Tasks Using EM......Page 41 Common Manageability Infrastructure:Advisory Framework......Page 42 Advisory Framework......Page 43 Guided Tuning Session......Page 44 Advisory Central......Page 45 Solution: Self-Managing Database......Page 46 Performance Monitoring Solutions......Page 47 ADDM Performance Monitoring......Page 48 ADDM Problem Classification System......Page 49 Accessing ADDM Advice......Page 50 ADDM Recommendations......Page 51 Performance Monitoring Solutions......Page 52 Performance Management Approach......Page 53 Database Performance Page......Page 54 Concurrency Wait Class: Drill Down......Page 55 Solution: Self-Managing Database......Page 56 Automate the SQL Tuning Process......Page 57 SQL Tuning Advisor Overview......Page 58 Plan Tuning Flow......Page 59 SQL Tuning Advisor Usage Model......Page 60 Solution: Self-Managing Database......Page 61 Overview of Automatic Shared Memory Management......Page 62 Benefits of Automatic Shared Memory Management......Page 63 Using EM to ConfigureAutomatic Shared Memory Management......Page 64 Solution: Self-Managing Database......Page 65 Segment Shrink Overview......Page 66 How Can I Shrink Segments?......Page 67 Segment Advisor......Page 68 Growth Trend Report......Page 69 Segment Resource Estimation......Page 70 Automatic Undo Retention Tuning......Page 71 Undo Advisor......Page 72 Redo Logfile Size Advisor......Page 73 Solution: Self-Managing Database......Page 74 Automatic Backup (DBCA Setup)......Page 75 Optimized Incremental Backup......Page 76 Defining Flash Recovery Area......Page 77 Flash Recovery Area Space Management......Page 78 Suggested Strategy......Page 79 Flashback Error Correction......Page 80 Solution: Self-Managing Database......Page 81 What Is Automatic Storage Management......Page 82 Hierarchy......Page 83 ASM Benefits......Page 84 ASM Files......Page 85 SQL Statements Issued to ASM Instances......Page 86 Enterprise Manager and ASM......Page 87 Summary......Page 88 How DBAs Spend Their Time?......Page 89 Enterprise Configuration Management......Page 90 How Oracle Database 10 g DBAs Spend Their Time......Page 91 Oracle Database 10g......Page 92 Oracle 10g : Twice as Manageable as Oracle9i......Page 93 What Does It Mean to You?......Page 94 DBA of the Future Does MORE......Page 95 LESS Cost for Businesses......Page 96 Summary......Page 97