Oracle Database 10g New Features: Oracle10g Reference for Advanced Tuning & Administration

Be the first to write a review

Overview

For those database administrators intending to upgrade or those who need to know the new features that will affect the entire Oracle database world, this book relates all of the features of this new database. The complete details of the database's new features, including database management and administration enhancements, are discussed. Improvements and additions to security, architecture, Internet features, real application clusters, and performance are also detailed.

...
See more details below
Available through our Marketplace sellers.
See All Options
Other sellers (Paperback)
  • All (4) from $1.99   
  • New (1) from $45.0   
  • Used (3) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$45.00
bluehouse
Seller since Tue Oct 07 09:37:03 EDT 2014

Feedback rating:

(184)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

More About This Book

Overview

For those database administrators intending to upgrade or those who need to know the new features that will affect the entire Oracle database world, this book relates all of the features of this new database. The complete details of the database's new features, including database management and administration enhancements, are discussed. Improvements and additions to security, architecture, Internet features, real application clusters, and performance are also detailed.

Read More Show Less

Product Details

  • ISBN-13: 9780974071602
  • Publisher: Rampant Techpress
  • Publication date: 12/28/2003
  • Series: Oracle In-Focus series
  • Edition description: 1ST
  • Pages: 544
  • Product dimensions: 6.36 (w) x 8.90 (h) x 1.62 (d)

Meet the Author

Mike Ault is a senior technical management consultant with TUSC and holds five Oracle master certificates. He is the author of 14 Oracle-related books, including Oracle 9i RAC and Oracle DBA Exam Cram. He lives in Alpharetta, Georgia. Madhu Tumma has been a software developer, IT manager, database administrator, and technical consultant and has worked on a wide variety of projects and environments, including mainframe, client-server, eBusiness, and managed services. He has consulted a variety of clients on database clusters, business continuity, and high availability solutions. He is a frequent speaker at Oracle World and IOUG, where he presented many technical papers and is the author of Oracle 9i RAC. He lives in Princeton, New Jersey. Daniel Liu is a senior Oracle Database Administrator at First American Real Estate Solutions. He has many years of industry experience in database administration and software development. He has worked with large-scale databases in multi-platform environments. His expertise includes Oracle database administration, performance tuning, Oracle networking, and Oracle Application Server. He lives in Anaheim, California. Donald K. Burleson is the author of 16 Oracle database books and is the editor in chief of Oracle Internals. He is an Oracle consultant with extensive experience designing and implementing Oracle8 databases, including systems architecture, project management, data warehouse design, implementation and tuning, tuning massively parallel Oracle databases, Oracle SQL tuning, using Oracle with SAP, and tuning very large Oracle databases. He lives in Kittrell, North Carolina.

Read More Show Less

Table of Contents

Using the Online Code Depot 1
Conventions Used in this Book 2
Acknowledgments 3
Preface 5
Chapter 1 Database Management 7
New Features 7
SYSAUX Tablespace 8
What is Automated Storage Management? 10
Automated Memory Management 18
Oracle Database 10g Automation Features 18
Automated RAC Services Configuration 33
Simplified Upgrade for RAC and OPS Databases 39
Drop Database 39
Conclusion 39
Chapter 2 Database Tuning and Performance 41
Database Resource Manager 41
Database Tuning Improvements 48
Application Tuning Improvements 52
Self-Tuning Features 62
Automatic SQL Tuning Process 65
Wait Event Model improvements 68
Conclusion 71
Chapter 3 Tablespace Management 72
Temporary Tablespace 72
Rename Tablespace 75
Bigfile Tablespace 76
New Cross-Platform Transportable Tablespaces 81
Conclusion 83
Chapter 4 Table and Index Features 84
Table and Index Partitions 84
Sorted Hash-Clustered Tables 96
Conclusion 98
Chapter 5 DML Features 100
Single-Set Aggregates in DML Returning Clause 100
Conclusion 117
Chapter 6 SELECT Features 118
Grouped Table Outer Join 118
Increased Number of Aggregates per Query 119
Remote Stored Functions in SELECT Statements 120
Case-Insensitive and Accent-Insensitive Query and Sort 122
Enhanced CONNECT BY Support 124
Oracle Expression Filter 127
SQL Regular Expressions 142
Row Timestamp 149
Conclusion 151
Chapter 7 Improved Existing Features 153
Existing Features That Have Changed 153
Asynchronous Row Change Data Capture 154
Cross-Platform Transportable Tablespaces 173
Enhanced Table Functions 182
External Tables Unload 185
Enhanced MERGE Functionality 202
Conclusion 206
Chapter 8 Initialization Parameters 207
Basic Parameters 207
Old Parameters 210
New Parameters 211
Conclusion 226
Chapter 9 Manageability Features 227
Easy Management 227
Self-Managing Database 228
Overview 228
Automatic Workload Repository (AWR) 229
Advisory Framework - ADDM 237
Server Alert Mechanism 238
Shared Server Configuration 240
Transaction Manageability 243
Statistics Collection 245
Audit Enhancements 250
Response File 252
Conclusion 253
Chapter 10 Utilities Improvements 254
Data Pump Utilities 254
New Scheduler Utilities 272
SQL*Plus Enhancements 280
Conclusion 282
Chapter 11 Network Features 283
Enhanced Oracle Networking 283
Export Directory Naming Entries to Local Naming File (tnsnames.ora) 285
Dynamic Connection Manager Configuration 287
Easy Connect Naming Method 288
Improved Network Outage Detection 292
Improved Connection Manager Access Rules 295
Automated Shared Server Configuration 297
Simplified Shared Server Configuration 298
Certificate Validation with Certificate Revocation Lists (CRLs) 301
Centralized CRL Management 305
Single Station Administration for Password Authentication 321
Transport Layer Security (TLS) Support 324
Conclusion 324
Chapter 12 Backup and Recovery Features 325
Flashback and RMAN 325
Extended Flashback Functions 327
RMAN Enhancements 342
Conclusion 358
Chapter 13 High Availability and Scalability 359
Avoiding Disruption 359
Online Redefinition 360
Synonyms and Views 365
LOGMINER 366
Data Guard Environment 368
Supplemental Logging 380
Real Application Clusters 381
Conclusion 384
Chapter 14 Oracle Streams 385
Enhancement Areas 385
Streams Overview 386
Configuration and Management 388
Downstream Capture 395
Asynchronous Change Data Capture 400
Rule Interface Improvements 401
Replication Enhancements 406
Migration from Advanced Replication 415
Messaging Enhancements 416
Conclusion 421
Chapter 15 Security Enhancements 422
Virtual Private Database 422
Audit Enhancements 428
Conclusion 435
Chapter 16 Business Intelligence 436
New Features and Enhancements 436
Materialized View Enhancements 437
Query Rewriting 439
Summary Management Improvements 443
SQLAccess Advisor 447
OLAP Enhancements 456
Support for Bioinformatics 460
Data Mining for Analytical 462
Conclusion 464
Chapter 17 Globalization Improvements 465
New Features 465
Globalization Development Kit Enhancements 466
Enhanced Character Set Scanner and Converter 478
Conclusion 497
Chapter 18 Oracle Enterprise Manager 498
Installation of OEM 498
Starting and Navigating in OEM 500
The EM2GO Interface 510
Conclusion 516
Index 517
About the Authors 526
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)
    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)