Oracle 10g New Features

Dr. Norbert Leiendecker

Leitender Systemberater
Server Technologies Competence Center
Oracle Deutschland GmbH, Geschftsstelle Hamburg
[email protected]

Oracle 10g

g = grid

Grid the idea

Mainframe Model

y Partitioning of one large server

y Built with high quality,
high cost parts
y Complete, integrated software
y High quality of service at
high cost

Grid Computing Model

y Coordinated use of many small

servers
y Built with low cost, standard,
modular parts Blades
y Open, Complete, integrated
software
y High quality of service at
low cost
3

Making of...
y
y
y
y
y
y
y

25 % of development effort was coding

2 years planning
700 developers, 150 testers, 80 product managers
3.000h testing each night on 1.000-plus computer grid
100.000 automated tests (9i: 30.000)
Source control system running on 9i RAC
24h Worldwide development (USA, Canada, India,
China, U.K., Australia)
4

Oracle10G Manageability Features

y Infrastructure

y Server Configuration

Easy OracleJVM Monitoring

SYSAUX Tablespace
Enhanced Wait Model
Database Features Usage
Tracking
Enhanced Database Time
Model
Top Consumers Performance
Monitoring & Diagnostic
JDBC: End-to-end
Java/J2EE Tracing
SQLJ: End-to-end Java/J2EE
Tracing
Automated Routine
Administration Tasks
Proactive Server-based
Alerts and Notifications
Database Statistics and
Workload Respository
Threshold-Based Alerts

y Instance Tuning

Automated Storage
Management
Configuration
Automated RAC Services
Configuration
Simplified Upgrade for
RAC and OPS Databases
Automated Enterprise
Manager Configuration
Automated Portable
Clusterware Installation
Automated Configuration
of Recovery Area
Out-of-the-box LDAP
Configuration
Simplified Initialization
Parameters
Easy Upgrade
Upgrade Information Tool
Simplified Database Install
User Default Tablespace

y Application Tuning

SQLAccess Advisor
User-Initiated Buffer Cache
Flushing
Materialized View Tuning
Database Resource Manager
API
- Adaptive Consumer Group
SQL Tuning Advisor
Mapping
Enhanced SQLAccess
Database Resource Manager
Advisor
- Fixed CPU Quota
Automatic Optimizer
New Performance Overview
Statistics Collection
Charts in Oracle Enterprise
y Backup and Recovery
Manager
Enhanced RMAN Reporting
Improved SQL Reporting
Backup Compression
Using Oracle Enterprise
Bounded Backup Window
Manager
Manage RMAN Scripts
Integration of Resource
Manager and Profiles
Recovery Area Full Alert
Automated Checkpoint
y Storage Management
Tuning
Multiple Default Temporary
Transaction Rollback &
Tablespace Support for
Recovery Monitoring
SQL Operations
Database Performance
Automated Storage
Analyzer
Management
Redo Logfile Sizing Advisor
Rename Tablespace
Automated SGA Memory
Tuning

Oracle10G Manageability Features

(continued)
y Network Management

Back Up Directory Naming

Entries to Local Naming File
Dynamic Connection
Manager Configuration
Easy Connect Naming
Method
Easy OCI/JDBC Install
Improved Network Outage
Detection
Automated LDAP Discovery
for Clients
Improved Connection
Manager Access Rules
Automated Shared Server
Configuration
Simplified Shared Server
Configuration Parameters

y Space, Object,
Transaction Mgmt

y Database Utilities

Automatic Undo Retention

Tuning
Segment Shrink Advisor
Segment Size Estimation
Online Segment Shrink
Proactive Tablespace
Management
Undo Advisor

y Scheduler

SQL*Plus - SPOOL
CREATE, REPLACE, and
APPEND Options
SQL*Plus - Show Recycle
Bin
SQL*Plus DBMS_OUTPUT After
SELECT
SQL*Plus - SET
SQLPROMPT Runtime
Variable Substitution
SQL*Plus COMPATIBILITY
Command Line Option
SQL*Plus - Run glogin.sql
and login.sql After Each
CONNECT
iSQL*Plus Input
Prompting

Core Scheduler Features

Usability and
Manageability
Monitoring
Recovery
Support for Jobs in a
Clustered Environment
Job Processing
ILMS Support
Increased Throughput
Redo Minimization
Dynamic Slave Pool

Database Management Challenges

?
?

Application
and SQL
Management
Storage
Management

System
Resource
Management

?
Backup and
Recovery
Management

Space
Management

Solution: Self-Managing Database

Enterprise
Manager
Database
Console

Application
and SQL
Management
Storage
Management

Monitor
Fix

Backup and
Recovery
Management

Alert

Automatic
Management

Common
Manageability
Infrastructure

System
Resource
Management
Advise
Space
Management

Common Manageability Infrastructure:

Automatic Workload Repository (AWR)
Automatic

Proactive

Automated
Tasks

Server
Alerts

Advisory
Framework

Automatic
Workload
Repository (AWR)

Data Warehouse
of the Database

Automatic collection
of important statistics

Efficient

Direct memory
access
9

Automatic Workload Repository

MMON

ADDM finds
top problems

without SQL

SYSAUX
WR Schema

BG

BG
FG

FG

In-memory
statistics
AWR
ASH
Statistics

7:00 a.m.
7:30 a.m.
8:00 a.m.
8:30 a.m.

Snapshot 1
Snapshot 2

Seven
days

Snapshot 3
Snapshot 4

SGA
8:30am
DBA

10

Statistics Level
STATISTICS_LEVEL

BASIC

TYPICAL

ALL

Turn off
all self-tuning
capabilities

Recommended
default value

Additional
statistics for
manual SQL
diagnostics
11

Database Feature Usage Metric Collection

Oracle
Database
10g

Once a week

DB Feature Usage
Statistics

MMON

Advanced Replication,
Oracle Streams, AQ,
Virtual Private Database,
Audit options,

AWR

DB High-Water Mark
Statistics
size of largest segment,
maximum number of sessions,
maximum number of tables,
maximum size of the database,
maximum number of data files,

DBA_FEATURE_USAGE_STATISTICS

DBA_HIGH_WATER_MARK_STATISTICS

HOST CONFIGURATION INFO

EM Console

EM Repository: ECM

12

Common Manageability Infrastructure:

Server Alerts
Automatic

Proactive

Automated
Tasks

Server
Alerts

Advisory
Framework

Automatic
Workload
Repository

Efficient

Push model

Enabled by default
Timely generation

13

Server Alerts
Enterprise
Manager

Automatic
Notification

Oracle Server
(SGA)

Guided
Resolution
Server
Alerts
Queue

Server monitors
itself
AWR

MMON

14

Server-Generated Alert Types

Metric-Based
Alert
Threshold
Alerts
Alert

97% Critical

Cleared

85% Warning

Cleared

MMON

NonThreshold
Alerts

Snapshot
Too Old

Resumable
Session
Suspended

Recovery Area
Low On
Free Space

Alert

Alert

Alert

Event-Based
15

Out-of-the-box Alerts
97% Critical
85% Warning

Locally
Managed

Tablespace
Tablespace
Space Usage

Resumable
Session
Suspended

Recovery Area
Low On
Free Space

Snapshot
Too Old

16

EM Interface to Alerts

17

Setting Alert Thresholds

18

Common Manageability Infrastructure:

Automated Tasks
Automatic

Proactive

Automated
Tasks

Server
Alerts

Advisory
Framework

Automatic
Workload
Repository

Pre-packaged routine
maintenance tasks

Resource usage
controlled

Efficient

Statistics collection
task scheduled
out-of-the-box
19

Automatic Optimizer Statistics Collection

DBA tracks and

gathers statistics

Targets
right objects
Resolves
two issues

Automatic statistics
collection

Determines
right samples

20

Gather Statistics Job

MAINTENANCE_WINDOW_GROUP

WEEKNIGHT_WINDOW

WEEKEND_WINDOW

10pm6am Mon to Fri

12am Sat to 12am Mon

gather_stats_job

AUTO_TASKS_JOB_CLASS

New PL/SQL-Package:
DBMS_SCHEDULER

AUTO_TASKS_CONSUMER_GROUP

21

Common Manageability Infrastructure:

Advisory Framework
Automatic

Automated
Tasks

Server
Alerts

Proactive

Advisory
Framework

Automatic
Workload
Repository

Uniform interface

Efficient

Fully integrated
22

Advisory Framework:
Automatic Database Diagnostic Monitor
SQL Tuning

PGA

Memory

SGA

ADDM
Access
Space

Buffer Cache
Shared Pool

Segment Advisor
Undo

Common
data source

AWR

Seamless
integration
23

Performance Diagnostics
ADDM

24

Guided Tuning Session

Create an advisor task

Adjust task parameters

Enterprise
Manager
Database
Console

Perform analysis

No

Accept
results?

Yes

Implement
recommendations

25

Advisor Central

26

Solution: Self-Managing Database

Enterprise
Manager
Database
Console

Application
and SQL
Management
Storage
Management

Monitor
Fix

Backup and
Recovery
Management

Alert

Automatic
Management

System
Resource
Management
Advise
Space
Management

Common
Infrastructure

27

Performance Monitoring Solutions

SGA
In-memory
statistics

MMON

Alerts

DBA
Reactive
Monitoring

Snapshots

ADDM

Proactive
Monitoring within
Oracle Server

ADDM
Results
AWR

28

ADDM Performance Monitoring

SGA
In-memory
statistics

30 minutes
MMON

Snapshots

ADDM

EM

ADDM
Results
AWR

ADDM
Results
29

Accessing ADDM Advice

30

ADDM Recommendations

31

Performance Management Approach

Host
CPU Bottlenecks

Memory Bottlenecks
Oracle
CPU/Waits
Uses ASH and AWR

SQL

Sessions

32

D E M O N S T R A T I O N

AWR-Snapshots
(swrfrpt.sql)

Solution: Self-Managing Database

Enterprise
Manager
Database
Console

Application
and SQL
Management
Storage
Management

Monitor
Fix

Backup and
Recovery
Management

Alert

Automatic
Management

System
Resource
Management
Advise
Space
Management

Common
Infrastructure

34

Automate the SQL Tuning Process

I can do
it for you!

SQL Workload

DBA
ADDM
High-load
SQL

SQL Tuning
Advisor

35

SQL Tuning Advisor Overview

Automatic
Tuning Optimizer

Comprehensive
SQL Tuning

Statistics Check
Optimization
Mode

Detect
Stale or Missing
Statistics

Plan Tuning
Optimization
Mode

Plan Tuning
(SQL Profile)

Access Analysis
Optimization
Mode

Add Missing
Index Run
Access Advisor

SQL Analysis
Optimization
Mode

SQL Tuning
Advisor

Restructure
SQL

36

Plan Tuning Flow

submit

Optimizer
(Tuning Mode)

create

slow

SQL Tuning
Advisor

SQL
Profile
use
No application
code
change
Optimizer
(Normal Mode)

Database
Users

output

fast
Well-Tuned
Plan
37

SQL Tuning Advisor Usage Model

Automatic Selection
AWR

ADDM

High-load SQL
SQL
Tuning
Advisor

Sources
AWR

Cursor Cache

Custom

Manual
Selection

Filter/Rank

SQL Tuning Set

STS

DBA
38

Solution: Self-Managing Database

Enterprise
Manager
Database
Console

Application
and SQL
Management
Storage
Management

Monitor
Fix

Backup and
Recovery
Management

Alert

Automatic
Management

System
Resource
Management
Advise
Space
Management

Common
Infrastructure

39

Automatic Shared Memory Tuning

SGA Pool

Online
Users

Buffer Cache

SGA Pool

Large
Batch
Jobs

Buffer Cache

Large Pool

Large Pool

SQL Cache

SQL Cache

Java Pool

Java Pool

sort
PGA Pool

Selftuning PGA
PGA_AGGREGATE_TARGET

sort
PGA Pool

40

Automatic Shared Memory Tuning

SGA Pool

Online
Users

Buffer Cache

SGA Pool

Large
Batch
Jobs

Buffer Cache

SGA_TARGET
Large Pool

Large Pool

Selftuning PGA

SQL Cache

SQL Cache

Java Pool

Java Pool

sort
PGA Pool

Selftuning SGA

PGA_AGGREGATE_TARGET

sort
PGA Pool

41

Automatic Shared Memory Management

Benefits
DB_CACHE_SIZE
SHARED_POOL_SIZE
LARGE_POOL_SIZE
JAVA_POOL_SIZE

Enable
Automatic Shared Memory Management

SGA_TARGET

42

Automatic Shared Memory Tuning:

sga_target - Parameter
Automatically managed components:
db_cache_size
shared_pool_size
if 0 min-value
large_pool_size
java_pool_size
Manually managed components:
keep/recycle buffer (db_keep_cache_size, db_recycle_cache_size)
buffer caches non-standard block size (db_<n>k_cache_size)
streams_pool_size

43

Solution: Self-Managing Database

Enterprise
Manager
Database
Console

Application
and SQL
Management
Storage
Management

Monitor
Fix

Backup and
Recovery
Management

Alert

Automatic
Management

System
Resource
Management
Advise
Space
Management

Common
Infrastructure

44

sql> ALTER TABLE <table> SHRINK SPACE

[COMPACT] [CASCADE];
y Table, IOT, Index, Partition, Subpartition, LOB segment,
MAV, MAV Log
y Segments in Tablespaces with automatic segment
management
y Row movement must be enabled
y Oracle compacts the segment, adjusts high water mark,
releases the recuperated space immediatly
y Not for:

Cluster, clustered table, objects with LONG column

Master table of ON COMMIT MAV
ROWID MAVs must be rebuild after shrink operation
45

Segment Shrink Overview

Data
Unused
Space

Data

Unused
Space
HWM

Shrink
Operation

Online and in-place

Reclaimed Space

Data
HWM
46

PAUSE

47

Solution: Self-Managing Database

Enterprise
Manager
Database
Console

Application
and SQL
Management
Storage
Management

Monitor
Fix

Backup and
Recovery
Management

Alert

Automatic
Management

System
Resource
Management
Advise
Space
Management

Common
Infrastructure

48

What Is Automatic Storage Management ?

Database

Tablespace

ASM solves
management problems
of Oracle databases.
ASM manages
Oracle files.

Segment

Extent

ASM does not

replace existing
concepts.
49

Hierarchy
Database Instance

ASM Instance

Database

ASM
disk group

Tablespace

Data file

Segment

Extent

Oracle
block

Or

ASM file

ASM disk
File system
file or
raw device

Allocation unit

Physical
block
50

ASM Instance

Lightweight instance
- Few processes
- No database to mount, metadata tripled mirrored in ASM
diskgroup

Initialization Parameters
INSTANCE_TYPE = OSM
LOCK_NAME_SPACE = +OSM1
OSM_POWER_LIMIT = 11
OSM_DISKSTRING = '/dev/rdsk/*s2', '/dev/rdsk/c1*'
OSM_DISKGROUPS = dgroupA, dgroupB
LARGE_POOL_SIZE = 8MB

51

ASM Files
CREATE TABLESPACE sample DATAFILE '+dgroupA';
Database file

Not visible from OS,

but to Oracle-Tools like RMAN

Automatic
ASM file
creation

1
2
3
4

ASM file automatically spread inside disk group dgroupA

(Default stripe size = 1 MB)

52

SQL Statements Issued to ASM Instances

CREATE DISKGROUP

ALTER SYSTEM
RESTRICTED SESSION

ASM Instance

ALTER DISKGROUP

DROP DISKGROUP
53

The Operational Stack

ASM

TODAY
Tables

Tables

Tablespace
Files

0010 0010 0010 0010 0010

0010 0010 0010 0010 0010

Tablespace
Files

File System

File System

Logical Vols

Logical Vols

Disks

Disk Group

The

ASM

best way to lower mgmt costs is to remove complexity

54

Mirroring with ASM: Failure Groups

Controller 1

Controller 2

y Storage resources organized into

Disk Groups and Failure Groups
y A Disk Group is a collection of disks
managed as a logical unit in which ASM
files are stored
y Disk Groups assigned by DBAs
y A Failure Group is a set of disks sharing a
common resource whose failure needs to be
tolerated

Failure Group 1 Failure Group 2

Redundant copies of an extent are stored

in separate Failure Groups

y Failure Groups assigned by DBAs or

automatically by ASM

Disk Group 1

55

Mirroring with ASM

y 3 choices for disk group redundancy

External: defers to hardware mirroring

Normal: 2-way mirroring
High: 3-way mirroring

56

Create or Delete Disk Groups

CREATE DISKGROUP dgroup1 DISK /dev/raw/raw*

CREATE DISKGROUP dgroupA NORMAL REDUNDANCY

FAILGROUP controller1 DISK
'/devices/diskA1' NAME diskA1 SIZE 120G,
'/devices/diskA2',
'/devices/diskA3'
FAILGROUP controller2 DISK
'/devices/diskB1',
'/devices/diskB2',
'/devices/diskB3';

DROP DISKGROUP dgroupA INCLUDING CONTENTS;

57

Traditional vs ASM
Remove Disk
1. List all data that is on
disk
2. Choose existing
filesystem to hold data
from dropped disk
3. Move data to new files
4. Rename files in
database
5. Remove disk from OS
6. Re-tune I/O

1.
2.

Issue drop disk command

Remove the disk from OS
when Oracle says it is done

58

Removing Disks from Disk Groups

ALTER DISKGROUP dgroupA DROP DISK Group2_0003;

Disk Group Rebalancing

Optional: Adjustment of power during rebalance

ALTER DISKGROUP dgroupA REBALANCE POWER 5;

59

Traditional vs ASM
Tune I/O
1.
2.
3.
4.
5.
6.

Daily monitor I/O

performance
Discover hot spots
Figure out how to remove
hot spots
Move data to new files
Rename files in database
Verify that hot spot is gone

This space intentionally left blank

60

Migration of File System Tablespace to ASM

RMAN> BACKUP AS COPY TABLESPACE USERS FORMAT +DGROUPA;

RMAN> SWITCH TABLESPACE USERS TO COPY;

61

ASM Summary
y
y
y
y
y
y
y
y

NO Volume-Manager
NO replacement for a filesystem
NO combination of VM and FS
Management component that manages storage and Tablespaces
of an Oracle system
Eliminates physical layout issues
Eliminates I/O tuning issues
Eliminates down-time issues to add/delete storage
No additional storage management tool is required to manage an
Oracle system

62

ASM Internet Seminar

63

Solution: Self-Managing Database

Enterprise
Manager
Database
Console

Application
and SQL
Management
Storage
Management

Monitor
Fix

Backup and
Recovery
Management

Alert

Automatic
Management

System
Resource
Management
Advise
Space
Management

Common
Infrastructure

64

Automatic Backup (DBCA Setup)

65

Defining Flash Recovery Area

66

Flash Recovery Area Space Management

Database file
backup
1
2
3
4

Recovery
Area

RMAN updates
1
list of files that
2
may be deleted. Backup files
to be deleted

Disk limit is
reached and a
new file needs
to be written
into the
Recovery Area.

Oracle deletes
files that are no
longer required
on disk.

Space pressure
occurs.
Warning is issued
to user.

67

Suggested Strategy

68

Odds and ends

y
y
y
y
y
y
y
y
y
y
y

ALTER TABLESPACE ... RENAME TO ...;

DROP DATABASE;
LOBS: Size = (4GB 1Byte) x db_block_size
Datatypes: BINARY FLOAT, BINARY DOUBLE
CREATE BIGFILE TABLESPACE...
DROP TABLE ... PURGE;
Regular expressions
Data Pump
Transportable Tablespaces cross platform !
FLASHBACK DATABASE;
FLASHBACK TABLE employees TO BEFORE DROP RENAME TO
employees_old;
y Native PL/SQL

69

sql> ALTER TABLESPACE <old_name> RENAME

TO <new_name>;

y
y
y
y
y
y

Tablespace and all its datafiles must be online

COMPATIBLE 10.0.0
No renaming of SYSTEM or SYSAUX tablespace
UNDO-Tablespace automatically renamed in SPFILE
Helpful for transportable Tablespaces!
Does NOT change the name of the datafile(s)

70

sql> DROP DATABASE;

y Database must be mounted (closed) in exclusive and
restricted mode
y Deletes all datafiles, controlfiles listed in the controlfile
y Deletes SPFILE if used

71

sql> DROP DATABASE;

y Database must be mounted (closed) in exclusive and
restricted mode
y Deletes all datafiles, controlfiles listed in the controlfile
y Deletes SPFILE if used

71

sql> CREATE BIGFILE TABLESPACE ...

y Contains one datafile or tempfile

y Up to 232 blocks 232 x 32K = 128 TB
y Locally managed, automatic segment spacemanagement

72

Regular expressions
- IEEE Posix standard
- Unicode Regular Expression Guidelines
of the Unicode Consortium
sql> SELECT first_name, last_name FROM employees WHERE
REGEXP_LIKE (first_name, '^Ste(v|ph)en$');
FIRST_NAME LAST_NAME
-------------------- ------------------------Steven
King
Steven
Markle
Stephen
Stiles
73

D E M O N S T R A T I O N

Analyze any logfile

with regexp_like

Oracle10g Data Pump

y High performance import and export

y
y
y
y

60% faster than 9i export (single thread)

15x-20x faster than 9i import (single thread)

Replacement for original Export and Import

Data Pump/Export Dumpfiles not compatible
Scales with parallel threads
Network transfer data between databases with
no intermediate representation

75

Oracle10g Data Pump

Example
sql> create directory dpump_dir as d:\oracle\dpump;
sql> create directory dpump_dir2 as d:\oracle\dpump2;
sql> create directory dpump_log as d:\oracle\dpump;
sql> grant read,write on directory dpump_dir to hr;
sql> grant read,write on directory dpump_dir2 to hr;
sql> grant read,write on directory dpump_log to hr;
$ expdp hr/hr
dumpfile=dpump_dir:hr_1.dmp,dpump_dir2:hr_2.dmp
logfile=dpump_log:hr.log parallel=2
76

Cross Platform Transportable Tablespace

Small Endian Platforms

Big Endian Platforms

Linux (Intel IA32/64)

Windows (Intel IA32/64)
Open VMS (Intel IA64)
Tru64 UNIX (Alpha)
Simple File Copy Within These

Solaris (SPARC)
High Speed
File Convert

HP-UX (Intel IA64)

RMAN

AIX (PowerPC)

HP-UX (PA-RISC)

Simple File Copy Within These

77

Cross Platform Transportable Tablespaces

Usage
y How Do I Determine Endianness?
SELECT endian_format
FROM v$transportable_platform tp, v$database d
WHERE tp.platform_name = d.platform_name;

y How Do I Perform the Conversion?

sql> alter tablespace example read only;
$ exp sys/sys transport_tablespace=y tablespace=example
$ rman target=sys/sys catalog=rman/rman@orcl
RMAN> CONVERT TABLESPACE EXAMPLE'
TO PLATFORM = "AIX-Based Systems (64-bit)"
FORMAT=D:\temp\transport_aix\example.dbf;

y Conversion on source or destination platform

78

Flashback error correction

Database

Customer

Order

Order Line

Flashback Database (instead of PITR)

y Restore database to time
y Uses flashback logs
Flashback Drop
y Restore dropped table
y Uses recycle bin
Flashback Table
y Restore all rows in table to time
y Uses UNDO in database
Flashback Transaction Query
y Query a committed Txn
Flashback Versions Query
y Query changes to rows over time
79

Flashback error correction

Database

Customer

Order

Order Line

Flashback Database (instead of PITR)

DB_RECOVERY_FILE_DEST
y Restore database to time
DB_RECOVERY_FILE_DEST_SIZE
y UsesDATABASE
flashback FLASHBACK
logs
ALTER
ON;
Flashback Drop
y Restore ANY
dropped
table
FLASHBACK
TABLE
Privilege
ALTER
TABLE
<table>
y Uses
recycle
bin ENABLE ROW MOVEMENT;
Flashback Table
y Restore ANY
all rows
in table
to time
FLASHBACK
TABLE
Privilege
ALTER
TABLE
<table>
ENABLE ROW MOVEMENT;
y Uses
UNDO
in database
Flashback Transaction Query
y Query a committed Txn
Flashback Versions Query
y Query changes to rows over time
79

PL/SQL interpreted native

Comparison

y Calculation of Fibonacci-Numbers
Environment
9i R2 interpreted

Time (s)
11.5

9i R2 native compiled

5.2

10g R1 interpreted

3.4

10g R1 native compiled

1.2

80

D E M O N S T R A T I O N

Fibonacci

Upgrading to 10g

82

Installation
y DELL Latitude C640:
Pentium 4
2 GHz
1GB RAM
y Installation von Festplatte
y Binaries 10 min
y Starter-Datenbank 7 min
y Lauffhiges System in 17 min!

83

Upgrade-Pfade und -Versionen

Oracle 9i
Oracle 8.1.7
Oracle 8.0.6
Oracle 7.3.4

Oracle 8.1.6
Oracle 8.0.5

Oracle 7.3

Oracle 8.0.4

Oracle 7.2

Oracle 8.0.3

Oracle 8.1.5

Oracle ...

84

Database Upgrade Assistant

Automates the upgrade process by performing all the tasks
you normally accomplish manually
y Shows upgrade progress
y Writes detailed trace and logging files
RAC-DBUA facilitates upgrade of 8.1.7, 9.0.1, 9.2 to
10.1.0

All database and configuration files are upgraded on all the

nodes in the cluster.

Customizable
Restartable
Silent mode for single command upgrade
Calls Post Upgrade Status Utility
85

Summary
y Oracle Database 10 gs self-management
capabilities work out-of-the-box.
y Customization of Oracle Database 10 gs selfmanagement capabilities can be done through
Enterprise Manager.
y Oracle Database 10 g is a self-managing database
which reduces administration overhead and
enables DBAs to become proactive strategists.

86

Summary
y Oracle Database 10 gs self-management
capabilities work out-of-the-box.
y Customization of Oracle Database 10 gs selfmanagement capabilities can be done through
Enterprise Manager.
y Oracle Database 10 g is a self-managing database
which reduces administration overhead and
enables DBAs to become proactive strategists.

Themen fr weitere Regiotreffen gesichert !

86

Data Dictionary 10g

Kostenlos bei Opitz Consulting

mailto:[email protected]

87

Q U E S T
A N S W

I O N S
E R S