Table of Contents

Page ix

Table of Contents

ACKNOWLEDGMENTS	xv
INTRODUCTION	xvii
1 Getting Started	1
Welcome to Oracle Database 10g and the ''Grid"	2
Upgrading to Oracle Database 10g	3
The DBUA	4
Performing Manual Upgrades	4
About the compatible Parameter	5
The Database Configuration Assistant	6
The SYSAUX Tablespace	6
Introducing the SYSAUX Tablespace	7
Managing Occupants of the SYSAUX Tablespace	8
Automatic Storage Management	9
ASM Features	9
The ASM Instance	10
Setting Up ASM Disks	11
Addressing ASM Disks	12
ASM and Data Dictionary Views	12
Oracle Database 10g Real Application Clusters	14
Portable Clusterware	14
Rolling Upgrades	14
Cluster Ready Services	15
Database Assistants	15
The gcs_server_processes Parameter	16
2 Server Manageability	17
Statistics Collection	18
Automated Statistics Collection	18
Collecting Data Dictionary Statistics	19
New DBMS_STATS Behaviors	21
New Table-Monitoring Behaviors	23
Flushing the Buffer Cache	23