Introduction

Introduction

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

How DBAs Spend Their Time Install: 6% Create and configure: 12% Load andarchive data: 6% Manage databasesystem: 55% Maintainsoftware: 6% Source: Survey conducted at IOUG Live! 2001

Oracle Database 10g Manageability Goals Reduce administration costs • Automatic versus manual • Intelligence versus data • Adaptive versus oversized • Integrated versus third-party • Preventive versus corrective • Act-and-succeed versus trial-and-error Reduce capital expenditures Reduce failure costs

Storagemanagement Applicationand SQLmanagement Systemresourcemanagement ? ? ? ? ? Backup andrecoverymanagement Spacemanagement Database Management Challenges

Spacemanagement Backup andrecoverymanagement Storagemanagement Applicationand SQLmanagement Systemresourcemanagement Oracle Database 10g Solution:Self-Managing Database Enterprise Manager 10g Monitor Alert Automaticmanagement Fix Advise Commonmanageabilityinfrastructure

How Oracle Database 10g DBAsSpend Their Time Proactiveand strategicplanning:45+% Scale to the Grid Create and configure: 6% Install: 3% Maintainsoftware: 3% Manage databasesystem: 25% Load data: 3%

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

Introduction

Introduction

Presentation Transcript

Introduction to introduction to introduction to … Optimization

INTRODUCTION/ INTRODUCTION

Introduction

INTRODUCTION

Introduction

Introduction