Oracle Database 10G New Features,9780072229479

Oracle Database 10G New Features

by
Edition: 1st
ISBN13: 9780072229479
ISBN10: 0072229470
Format: Paperback
Pub. Date: 2004-04-13
Publisher(s): McGraw-Hill Education
Upgraded Edition: Click here!
List Price: $42.00

Buy New

Usually Ships in 2-3 Business Days.
$41.58
Add to Cart

Rent Book

Select for Price
Add to Cart
There was a problem. Please try again later.

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Buy from our Marketplace starting at $17.60

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

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

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.