Oracle Database 10G New Features

by Freeman, Robert

• ISBN13: 9780072229479
• ISBN10: 0072229470
• Edition: 1st
• Format: Paperback
• Copyright: 2004-04-13
• Publisher: McGraw-Hill Education

Summary

Here is an invaluable overview of all the cutting-edge features of Oracle's latest database release, Oracle Database 10g. Includes expert commentary throughout from world-renowned Oracle guru Jonathan Lewis. This is an ideal resource for decision-makers and IT staff preparing for upgrades or migration.

Table of Contents

ACKNOWLEDGMENTS	xv
INTRODUCTION	xvii
1 Getting Started	1	(16)
Welcome to Oracle Database 10g and the "Grid"	2	(1)
Upgrading to Oracle Database 10g	3	(3)
The DBUA	4	(1)
Performing Manual Upgrades	4	(1)
About the compatible Parameter	5	(1)
The Database Configuration Assistant	6	(1)
The SYSAUX Tablespace	6	(3)
Introducing the SYSAUX Tablespace	7	(1)
Managing Occupants of the SYSAUX Tablespace	8	(1)
Automatic Storage Management	9	(5)
ASM Features	9	(1)
The ASM Instance	10	(1)
Setting Up ASM Disks	11	(1)
Addressing ASM Disks	12	(1)
ASM and Data Dictionary Views	12	(2)
Oracle Database 10g Real Application Clusters	14	(3)
Portable Clusterware	14	(1)
Rolling Upgrades	14	(1)
Cluster Ready Services	15	(1)
Database Assistants	15	(1)
The gcs_server_processes Parameter	16	(1)
2 Server Manageability	17	(22)
Statistics Collection	18	(5)
Automated Statistics Collection	18	(1)
Collecting Data Dictionary Statistics	19	(2)
New DBMS STATS Behaviors	21	(2)
New Table-Monitoring Behaviors	23	(1)
Flushing the Buffer Cache	23	(1)
Database Resource Manager New Features	24	(3)
Reverting Back to the Original Consumer Group	24	(1)
Setting the Idle Timeout	25	(1)
Creating Mappings for Automatic Assignment of Sessions to Consumer Groups	25	(2)
Scheduler Changes	27	(6)
Overview of The Scheduler	27	(1)
Practical Use of The Scheduler	27	(6)
User-Configurable Default Tablespaces	33	(1)
Tablespace Groups and Multiple Default Temporary Tablespaces	33	(3)
Assigning Temporary Tablespaces to Tablespace Groups	34	(1)
Defining a Tablespace Group as the Default Temporary Tablespace	34	(1)
Tablespace Group Data Dictionary View	35	(1)
Renaming Tablespaces	36	(1)
Dropping Databases	36	(1)
Larger LOBs	37	(1)
Automatic Undo Retention	37	(1)
Shrinking and Compacting Segments Online	37	(1)
Using New Online Redefinition Features	38	(1)
3 Performance Tuning	39	(28)
Improvements to the Wait Interface	40	(3)
Changes to the V$EVENT_NAME View	40	(1)
New Wait Information in V$SESSION	41	(1)
Using V$SESSION to Find Blocking Sessions	42	(1)
The V$SESSION_WAIT_HISTORY View	42	(1)
V$SESSION_WAIT_CLASS and V$SYSTEM_WAIT_CLASS Views	42	(1)
New Histogram Views	42	(1)
The Database Common Management Infrastructure	43	(18)
CMI Architecture Overview	43	(1)
The Automatic Workload Repository	44	(6)
Server-Based Advisors	50	(9)
Server-Generated Alerts	59	(2)
Automatic SGA Tuning	61	(1)
Self-Tuning Checkpointing	62	(1)
New Oracle Database 10g Trace Functionality	62	(1)
Sorted Hash Clusters	63	(2)
Example of Using a Sorted Hash Cluster	63	(2)
Shared Server Changes	65	(2)
Changes to Shared Server Configuration	65	(1)
MTS Parameters Obsoleted	66	(1)
The V$DISPATCHER_CONFIG View	66	(1)
Tracing Shared Server Sessions	66	(1)
4 Security	67	(6)
Virtual Private Database New Features	68	(2)
Column-Level Privacy	68	(1)
New VPD Policies	69	(1)
VPD Support for Oracle Parallel Query	70	(1)
Oracle Database 10g Auditing New Features	70	(2)
New Columns in DBA_AUDIT_TRAIL	70	(1)
Fine-Grained Auditing New Features	71	(1)
Directory (LDAP) Based New Features	72	(1)
5 Availability and Recoverability	73	(40)
General Database Recovery Improvements	74	(3)
Easier Recovery Through the resetlogs Command	74	(2)
Changes to the alter database archivelog Command	76	(1)
New and Changed Oracle Database 10g Database Backup Commands	76	(1)
RMAN Improvements	77	(15)
Using the Flash Recovery Area	78	(5)
Using Backup Copies and Fast Recovery	83	(2)
Use RMAN to Back Up the Current Control File	85	(1)
Using the catalog and uncatalog Commands	85	(1)
Dropping a Database in RMAN	86	(1)
Unregistering a Database in RMAN	86	(1)
Changes to Incremental Backups	87	(2)
Recovering Datafiles Not Backed Up	89	(1)
Automatic Channel Failover	89	(1)
Compressing RMAN Backups	90	(1)
Controlling Backup Rates and Duration	91	(1)
New Flashback Features	92	(10)
Flashback Database	92	(5)
Flashback Drop	97	(2)
Flashback Versions Query	99	(1)
Configuring Guaranteed Undo Retention	100	(1)
Flashback Transaction Query	101	(1)
Flashback Table	101	(1)
New Transaction Recovery Monitoring Features	102	(1)
New Data Guard Features	103	(10)
Apply Redo in Real Time	104	(1)
The valid_for Attribute	105	(2)
Redo Transmission Enhancements	107	(1)
New Standby Database Parameters	107	(1)
Changes to Standby Database Startups	108	(1)
ARCH Process Writes to Standby Redo Logs	108	(1)
Assign Threads to Standby Redo Log Groups	108	(1)
Logical Standby Database Enhancements	109	(4)
6 Business Intelligence	113	(48)
Oracle Data Pump	114	(20)
Oracle Data Pump Architecture	114	(4)
Data Pump Data Dictionary Views	118	(1)
Data Pump Interactive Mode	118	(2)
Data Pump API	120	(1)
Data Pump Export	120	(8)
Data Pump Import	128	(6)
Bigfile Tablespaces	134	(4)
What Are Bigfile Tablespaces?	134	(1)
Why Bigfile Tablespaces?	134	(1)
Bigfile Tablespace Management	135	(2)
Bigfile Tablespaces and Extended ROWIDs	137	(1)
Cross-Platform Transportable Tablespaces	138	(3)
Introduction to Cross-Platform Transportable Tablespaces	138	(1)
Datafile Byte Ordering: Endian Formats	139	(2)
Enhanced Merge Functionality	141	(5)
New merge Conditional Clauses and Extensions	141	(2)
Optional delete Clause in the merge Statement	143	(1)
Enhanced External Table Functionality	143	(1)
Writing to External Tables	143	(2)
Projecting Columns in External Tables	145	(1)
New Materialized View, Query Rewrite, and Summary Management DDL Features	146	(10)
Partition Change Tracking Enhancements	146	(1)
Query Rewrite Enhancements	147	(6)
Mview Fast Refresh Enhancements	153	(1)
Summary Management DDL Enhancements	154	(2)
New Partitioning Features	156	(5)
Index-Organized Table Partitioning Improvements	156	(1)
Hash-Partitioned Global Indexes	157	(2)
Partitioned Index Maintenance	159	(1)
Skipping Unusable Indexes	160	(1)
7 Application Development	161	(28)
Bulk Bind Improvements	162	(2)
Processing Sparse Collections	162	(2)
Exception Handling	164	(1)
SQL and PLSQL Regular Expressions	164	(8)
What Are Regular Expressions?	164	(1)
Using Regular Expressions in Oracle Database 10g	164	(8)
Case- and Accent-Insensitive Searches	172	(2)
User-Specified Quote Character Assignment	174	(1)
PLSQL New Packages of Note	174	(2)
The utl_compress Package	174	(1)
The utl_mail Package	175	(1)
Other New PLSQL Packages	176	(1)
Oracle Collections	176	(5)
Creating Temporary Tables with VARRAY Columns	176	(1)
Changing the VARRAY Size	177	(1)
Defining the Tablespace of a Nested Table	177	(1)
ANSI Support for Nested Tables and VARRAY Columns	178	(3)
The PLSQL Compiler	181	(6)
New PLSQL Compiler	181	(2)
Natively Compiled PLSQL New Features	183	(1)
Fine-Grained Debug Privileges	184	(1)
PLSQL Compile-Time Warnings	184	(3)
Improvements to the dbms_profiler Procedure	187	(1)
Table Function Enhancements	187	(1)
New Connect String Format	187	(2)
8 Other Database New Features	189	(22)
Calling Remote Stored Procedures	190	(1)
Workspace Manager Enhancements	190	(10)
New Functionality in the dbms_wm Package	191	(2)
Multiparent Workspaces	193	(3)
Workspace Manager Events	196	(1)
Exporting, Importing, and Loading Versioned Data	197	(2)
Workspace Continuous Refresh	199	(1)
Other Improvements for Workspace Manager	199	(1)
Streams Enhancements	200	(2)
SQL* Plus Enhancements	202	(3)
Enhancements to the describe Command	202	(1)
Enhancements to the spool Command	203	(1)
Changes to the Behavior of the SQL* Plus Profile Files	203	(1)
New define Variables	204	(1)
Capability to Do Variable Substitution at the SQL Prompt	204	(1)
The New SQL*Plus compatibility Command	205	(1)
Support for Whitespace in File- and Pathnames	205	(1)
Other SQL*Plus Enhancements and New Features	205	(1)
SQL Language New Features	205	(3)
Data Type Enhancements	206	(1)
Moving Data from BFILEs to a LOB	206	(1)
LOBs and the before row insert Trigger	206	(1)
New Functionality for the returning Clause	206	(1)
SQL Modeling	207	(1)
Using Aggregates in the returning Clause	207	(1)
Grouped Table Outer Joins	208	(1)
Removal of Aggregate and SQL Statement Length Limitations	209	(1)
New connect by Functionality	209	(2)
Example Using connect_by_iscycle	210	(1)
Example Using connect_by_isleaf	210	(1)
Example Using connect_by_root	210	(1)
9 Oracle Enterprise Manager 10g	211	(20)
Introducing the Redesigned OEM Architecture	212	(2)
Server Tier	213	(1)
Client Tier	213	(1)
Middle Tier	213	(1)
Communication Components	214	(1)
Changes to OEM Installation	214	(3)
Grid Control	215	(1)
Database Control	215	(1)
Studio Control	216	(1)
Connecting to OEM	216	(1)
Key New Features in OEM	217	(1)
Introducing the Revamped OEM Home Page	218	(2)
Consolidated Management with Target Home Pages	218	(2)
Server-Generated Alerts	220	(1)
Key New Management Features	220	(2)
Provisioning	220	(1)
Job Scheduler	221	(1)
New OEM Administration and Maintenance Features	222	(7)
Performance Tuning	225	(2)
OEM Grid Control	227	(1)
Top Sessions	227	(1)
Top SQL Assessment	227	(2)
Introducing Oracle EM2Go	229	(1)
EM2Go Home Page	229	(1)
Other New OEM Related Features	230	(1)
Baselining	230	(1)
History	230	(1)
Oracle Data Pump	230	(1)
Related Links	230	(1)
Alert Log Viewer	230	(1)
Appendix: Oracle Database 10g New Processes	231	(2)
Index	233