1 Introduction Copyright 2004 Oracle All rights reserved

Course Objectives In this course, you will gain hands-on experience with: • Advanced backup

How DBAs Spend Their Time Install: 6% Create and configure: 12% Load and archive

Oracle Database 10 g Manageability Goals Reduce administration costs • • Automatic versus manual

Database Management Challenges ? ? Application and SQL management Storage management ? System resource

Oracle Database 10 g Solution: Self-Managing Database Enterprise Manager 10 g Storage management Application

How Oracle Database 10 g DBAs Spend Their Time Proactive and strategic planning: 45+%

Student Preface Even if topics might not seem to be relevant to you now,

Slides: 8

Download presentation

Course Objectives In this course, you will gain hands-on experience with: • Advanced backup and recovery concepts • Implementing a backup and recovery strategy • Employing database monitoring practices • Basic database tuning • Scheduling of tasks 1 -2 Copyright © 2004, Oracle. All rights reserved.

How DBAs Spend Their Time Install: 6% Create and configure: 12% Load and archive data: 6% Manage database system: 55% Maintain software: 6% Source: Survey conducted at IOUG Live! 2001 1 -3 Copyright © 2004, Oracle. All rights reserved.

Oracle Database 10 g Manageability Goals Reduce administration costs • • Automatic versus manual Intelligence versus data Reduce capital expenditures • • Adaptive versus oversized Integrated versus third-party Reduce failure costs • • 1 -4 Preventive versus corrective Act-and-succeed versus trial-and-error Copyright © 2004, Oracle. All rights reserved.

Database Management Challenges ? ? Application and SQL management Storage management ? System resource management ? ? Backup and recovery management 1 -5 Space management Copyright © 2004, Oracle. All rights reserved.

Oracle Database 10 g Solution: Self-Managing Database Enterprise Manager 10 g Storage management Application and SQL management Monitor Fix Backup and recovery management 1 -6 Alert Automatic management Common manageability infrastructure System resource management Advise Space management Copyright © 2004, Oracle. All rights reserved.

How Oracle Database 10 g DBAs Spend Their Time Proactive and strategic planning: 45+% Scale to the Grid Maintain software: 3% 1 -7 Install: 3% Create and configure: 6% Manage database system: 25% Load data: 3% Copyright © 2004, Oracle. All rights reserved.

Student Preface Even if topics might not seem to be relevant to you now, your job functions may change due to: • New products or methods • Changes in your employment • Changes in corporate structure • Enhancements in applications 1 -8 Copyright © 2004, Oracle. All rights reserved.