Oracle Essentials Oracle Database 11g (67 page)

Provide support for optimizer hints for workspaces and a wider range of data maintenance operations on workspace-enabled tables.

Chapter 9: Oracle and T
ransaction Processing
Oracle has been one of the leading databases for OLTP for many years. Although Oracle Database 11
g
includes many enhancements to improve the performance and manageability of the Oracle database when used for OLTP, there were no significant new features covered in this chapter.

Chapter 10: Oracle Da
ta Warehousing and Business
Intelligence

In addition to covering the database and data warehousing, this chapter describes Oracle’s current suites of business intelligence tools and business intelligence applications. New features in the database for data warehousing include:
Database OLAP Option query rewrite and improved manageability
The OLAP Option is now refreshed similarly to materialized views, and the database optimizer can transparently redirect SQL queries to the OLAP Option stored summaries.

Binary XML

Performance of binary XML is up to 15 times that of XML LOBs stored in Oracle.

Partitioning enhancements

There are new composite types (list-hash, list-list, list-range, and range-range) and a new partitioning type, interval partitioning, that automatically creates range partitions as needed.

Data Mining Option enhancements

This option now provides generalized Linear Model algorithms and automated data preparation.

Chapter 10: Oracle Data Warehousing and Business Intelligence

|

353

Chapter 11: Oracle and High A
vailability
This chapter describes the Oracle characteristics that keep your database up and highly available. New features include:

Automatic Storage Management Fast Mirror Resynchronization
Resynchronizes only changed ASM disk extents for faster recovery.

Flashback Transaction command

Backs out an individual transaction and dependent transactions.

Total Recall Option

Provides a Flashback Data Archive capability to query data as of a previous date.

Active Data Guard Option

You can now query your standby database while redo apply is active; fast-start failover is also possible.

Data Guard Management

SQL*Plus can be used as an interface for Data Guard SQL statements and initialization parameters.

Chapter 12: Oracle and Har
dware Architecture
New coverage in this chapter’s description of various hardware architectures includes the implications of multicore CPUs and an introduction to Oracle’s Optimized Warehouse Initiative. A new option in this chapter is:
Advanced Compression Option

Provides compression for insert, update, and delete operations.

Chapter 13: Oracle Distribut
ed Databases and
Distributed Data

This chapter focuses on using Oracle as the core database for accessing data stored in non-Oracle databases, as well as using Oracle as a distributed database. New features include:

Transparent Gateway query performance

Oracle Database 11
g
supports parallel retrieval for queries against non-Oracle databases through Transparent Gateways.

Extended Transparent Gateway targets

Provides new Gateways for ADABAS, IMS, and VSAM.

Messaging server

These enhancements improve the performance and reliability of the server.

354

|

Appendix A: What’s New in This Book for Oracle Database 11g
Database Change Notification

You can now enable notification when individual rows change.

Oracle Streams enhancements

It is now possible to log active online log files for DDL and DML and to run from a single Real Application Clusters (RAC) node for the entire RAC cluster.

Chapter 14: Oracle Ex
tended Datatypes
This chapter describes capabilities beyond Oracle’s standard set of datatypes. New features enhancing Oracle’s support of extended datatypes include:
Object-relational enhancements

A method invocation scoping operator is now available.

Database as a Service-Oriented Architecture (SOA) services provider
PL/SQL packages, procedures, and functions are now exposed as web services.

Multimedia (formerly inter
Media
) enhancements

These include media size limits extended to those of BLOBs, a higher-performing BLOB implementation accessible via SecureFiles, and DICOM medical imaging support.

Spatial enhancements

Support for three-dimensional geometry objects and enhanced web services.

Chapter 15: Bey
ond the Oracle Database
This chapter covers the world beyond the boundaries of the Oracle database. The chapter now describes Application Express (ApEx), an HTML-based development tool that can be used to create applications that run from the Oracle database platform. It also includes Fusion Middleware, which has combined the software stack of Oracle Application Server as well as additional components, and the Oracle SOA Suite, aimed at SOA developers.

Chapter 15: Beyond the Oracle Database

|

355

Appendix B

APPENDIX B

Additional Resources

2

In this concise volume, we have attempted to give you a firm grounding in all the basic concepts you need to understand Oracle and use it effectively. We hope we have accomplished this goal. At the same time, we realize that there is more to using a complex product such as Oracle than simply understanding how and why it works the way it does. Although you can’t use Oracle without a firm grasp of the founda-tions of the product, you will still need details if you’re actually going to implement a successful system.

This appendix lists two types of additional sources of information for the topics covered in this book—relevant web sites, which act as a constantly changing resource for a variety of information, and a chapter-by-chapter list of relevant books, articles, and Oracle documentation.

For the chapter-by-chapter list, the sources fall into two basic categories: Oracle documentation and third-party sources. Typically, the Oracle documentation provides the type of hands-on information youwill need regarding syntax and keywords, and the third-party sources cover the topics in a more general and problem-solving way.

We have listed the third-party sources first and ended each listing with the relevant Oracle documentation. Also note that some of the volumes listed here include previous Oracle release names in their titles. You can assume that by the time you are reading this, similar volumes exist (or will soon exist) for whatever version of Oracle you may be using (for example, Oracle Database 11
g
).

Web Sites

Oracle Corporation: http://www.oracle.com

The home of the company. Latest information and marketing, as well as some good technical and packaging information.

356

Oracle Technology Network: http://otn.oracle.com

The focal point of Oracle Corporation’s attempt to reach a wider audience of developers. Youcan find tons of stu

ff at the Oracle Technology Network

(OTN), including low-cost developer versions or free downloads of most Oracle software and lots of information and discussion forums.

International Oracle Users Group (IOUG): http://www.ioug.org
The International Oracle Users Group web site includes information on meet-ings, links to Oracle resources, a technical repository, discussion forums, and special interest groups.

OraPub, Inc.: http://www.orapub.com

Craig Shallahamer’s site devoted to all things Oracle. Craig was a long-time Oracle employee in the performance analysis group and technical reviewer for various editions of this book.

Quest Software: http://www.quest.com

The Quest Software site for all things PL/SQL-oriented, as well as information on Oracle database administration, Java database programming, and other topics.

O’Reilly Media, Inc.: http://www.oreilly.com

The O’Reilly web site, which contains web pages for each book and a variety of other helpful information. See
http://www.oreilly.com/catalog/oressentials4/
for errata and other information for this book.

Books and Oracle Documentation

The following books and Oracle documentation provide additional information for each chapter of this book.

Chapter 1: Intr
oducing Oracle
Ellison, Lawrence.
Oracle Overview and Introduction to SQL
. Belmont, CA: Oracle Corporation, 1985.

Greenwald, Rick et al.
Professional Oracle Programming
, Indianapolis, IN: Wrox/

John Wiley & Sons, 2005.

Kreines, David, and Brian Laskey.
Oracle Database Administration: The Essential Reference
. Sebastopol, CA: O’Reilly Media, Inc., 1999.

Loney, Kevin, and Bob Bryla.
Oracle10
g
DBA Handbook
. New York, NY: McGraw-Hill, 2005.

Ralston, Anthony, ed.
Encyclopedia of Computer Science and Engineering
. New York, NY: Nostrand Reinhold Company, 1983.

Books and Oracle Documentation

|

357

Thome, Bob.
Achieving a 24x7 e-Business Leveraging the Oracle Database
. Belmont, CA: Oracle Corporation, 2000.

Flashback Data Archive (An Oracle White Paper)
. Redwood Shores, CA: Oracle Corporation, 2007.

Oracle Database 11
g
Concepts
. Redwood Shores, CA: Oracle Corporation, 2007.

Oracle Database New Features Guide 11
g
Release 1.
Redwood Shores, CA: Oracle Corporation, 2007.

Oracle Database 11
g
: Real Application Testing and Manageability Overview (An Oracle White Paper)
. Redwood Shores, CA: Oracle Corporation, 2007.

Chapter 2: Oracle Ar
chitecture
Kreines, David, and Brian Laskey.
Oracle Database Administration: The Essential Reference
. Sebastopol, CA: O’Reilly Media, Inc., 1999.

Loney, Kevin.
Oracle Database 10
g
The Complete Reference
. New York, NY: McGraw-Hill, 2004.

Oracle Database Concepts
. Redwood Shores, CA: Oracle Corporation, 2007.

Chapter 3: Installing and Running Oracle

Kreines, David, and Brian Laskey.
Oracle Database Administration: The Essential
Reference
. Sebastopol, CA: O’Reilly Media, Inc., 1999.

Toledo, Hugo, and Jonathan Gennick.
Oracle Net8 Configuration and Troubleshooting
. Sebastopol, CA: O’Reilly Media, Inc., 2000.

Oracle Database Concepts
. Redwood Shores, CA: Oracle Corporation, 2007.

Oracle Database Installation Guide
. 11
g Release for Microsoft Windows.
Redwood Shores, CA: Oracle Corporation, 2007.

Oracle Database Net Services Administrators Guide
. Redwood Shores, CA: Oracle Corporation, 2007.

Oracle Enterprise Manager Basic Installation and Configuration
. Redwood Shores, CA: Oracle Corporation, 2007.

Chapter 4: Da
ta Structures
Date, C.J.,
The Relational Database Dictionary
. Sebastopol, CA: O’Reilly Media, Inc., 2006.

Ensor, Dave, and Ian Stevenson.
Oracle Design
. Sebastopol, CA: O’Reilly Media, Inc., 1997.

358

|

Appendix B: Additional Resources

Harrington, Jan L.
Relational Database Design Clearly Explained
. San Francisco, CA: AP Professional, 1998.

Oracle Database Concepts
. Redwood Shores, CA: Oracle Corporation, 2007.

Chapter 5: Managing Oracle

Feuerstein, Steven, with Bill Pribyl.
Oracle PL/SQL Programming,
Fourth Edition.

Sebastopol, CA: O’Reilly Media, Inc., 2005.

Greenwald, Rick, and David Kreines.
Oracle in a Nutshell: A Desktop Quick
Reference.
Sebastopol, CA: O’Reilly Media, Inc., 2002.

Himatsingka, Bhaskar, and Juan Loaiza. “How to Stop Defragmenting and Start Liv-ing: The Definitive Word on Fragmentation.” Paper no. 711. Belmont, CA: Oracle Corporation, 1998.

Kuhn, Darl, and Scott Schulze.
Oracle RMAN Pocket Reference.
Sebastopol, CA: O’Reilly Media, Inc., 2002.

Manning, Paul, and Angelo Pruscino.
Simplify your Job—Automatic Storage Management (Oracle White Paper
). Redwood Shores, CA: Oracle Corporation, 2003.

Legato Storage Manager Administrator’s Guide
. Belmont, CA: Oracle Corporation, 1999.

Oracle Database Administrator’s Guide
. Redwood Shores, CA: Oracle Corporation, 2007.

Oracle Database Backup and Recovery Basics
. Redwood Shores, CA: Oracle Corporation, 2007.

Oracle Database Concepts
. Redwood Shores, CA: Oracle Corporation, 2007.

Oracle Database Storage Administrator’s Guide
. Redwood Shores, CA: Oracle Corporation, 2007.

Oracle Database VLDB and Partitioning Guide
. Redwood Shores, CA: Oracle Corporation, 2007.

Oracle Enterprise Manager Concepts
. Redwood Shores, CA: Oracle Corporation, 2007.

Feature Overview: Oracle Enterprise Manager EM2Go
. Redwood Shores, CA: Oracle Corporation, 2003.

Managing the Complete Oracle Environment with Oracle Enterprise Manager (Oracle
White Paper
). Redwood Shores, CA: Oracle Corporation, 2003.

Books and Oracle Documentation

|

359

Chapter 6: Oracle S
ecurity, Auditing, and Compliance
Knox, David
Effective Oracle Database 10
g
Security by Design
. New York, NY: McGraw-Hill, 2005.