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