Skip Headers
Oracle® Database Installation Guide
10g Release 2 (10.2) for Microsoft Windows (32-Bit)

Part Number B14316-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

What's New in Oracle Database for Windows?

This chapter describes new and deprecated features of Oracle Database 10g release 2 (10.2) for Windows and provides pointers to additional information. It also retains new and deprecated features information from previous releases to help those users migrating to the current release.

The following sections describe the new features in Oracle Database:

See Also:

Oracle Database Support on Windows Vista

Oracle Database is supported on Windows Vista with the 10.2.0.3 release. Use the Oracle Database 10g Release 2 (10.2.0.3) for Microsoft Windows Vista media available in the 10.2.0.3 media pack and the Oracle Technology Network site. Do not install Oracle Database on Windows Vista using the media for Oracle Database 10g Release 2 (10.2) for Microsoft Windows.

.NET Requirements on Windows Vista

To run Oracle Data Provider for .NET on Windows Vista, you must install .NET Framework version 1.1.

See Also:

Oracle Database 10g Release 2 (10.2) New Features for Windows

This section contains this topic:

Oracle Data Provider for .NET

Oracle Data Provider for .NET 10g Release 2 (10.2) has the following enhancements:

See Also:

Oracle Data Provider for .NET Developer's Guide

Oracle Database Extensions for .NET

Oracle Database Extensions for .NET provides the following new functionality:

Oracle Database hosts the Microsoft Common Language Runtime (CLR) in an external process, outside of the Oracle database process, but on the same computer. With the integration of Oracle Database with the Microsoft Common Language Runtime (CLR), applications can run .NET stored procedures on Oracle Database running under Windows 2000, Windows 2003, and Windows XP.

See Also:

Oracle Services for Microsoft Transaction Server

Distributed Transactions in an Oracle Real Application Clusters (RAC) environment detect failures and start the failover and failback processes automatically.

See Also:

Oracle Cluster Ready Services (CRS) Name and Functionality Change

Starting with this release, Oracle Cluster Ready Services (CRS) has the following changes:

Oracle Data Provider for .NET New Features for Release 10.1.0.3

New Oracle Data Provider for .NET release 10.1.0.3 features are as follows:

Command Cancellation

The following two new features enhance command cancellation:

Statement Caching

This feature provides and manages a cache of PL/SQL statements for each session. On the server, it means that cursors are ready to be used without the need to parse the statement again during that session. You can use statement caching with connection pooling to improve performance and scalability.

DerivedParameters Method

This method populates the parameter collection for the OracleCommand code that represents a stored procedure or function by querying the database for the parameter information.

Support for .NET 1.1 Enhancements

These enhancements expose new ADO.NET functionality that was introduced in Microsoft .NET Framework 1.1.

See Also:

Oracle Data Provider for .NET Developer's Guide

Oracle Database 10g Release 2 (10.2) Deprecated Components

The following Oracle Database 10g release 2 (10.2) components that were part of Oracle Database 10g release 1 (10.1) are not available for installation with Oracle Database 10g release 2 (10.2):

Oracle Database 10g Release 1 (10.1) New Features for Windows

This section contains these topics:

Automatic Storage Management

Automatic Storage Management enables creation of a single disk group from a collection of individual disk devices.

See Also:

Oracle Database Administrator's Guide for more information about Automatic Storage Management

Database Password Encryption

When a user attempts a remote login to an Oracle Database 10g Release 2 (10.2) database, the password is automatically encrypted before it is sent to the remote database.

See Also:

"Administering a Database on Windows" in Oracle Database Platform Guide for Microsoft Windows (32-Bit)

Data Pump Import and Data Pump Export

Two new utilities, Data Pump Import and Data Pump Export, offer faster transfer of files to and from Oracle databases. The previous file transfer utilities, Import and Export, are retained for use with Oracle databases created with earlier versions of Oracle software.

See Also:

"Database Tools on Windows" in Oracle Database Platform Guide for Microsoft Windows (32-Bit)

Instant Client

The Instant Client feature of Oracle Call Interface (OCI) simplifies OCI installation. The activation of Instant Client mode is only dependent on the ability to load the Instant Client data shared library. It requires only two dynamic link libraries to be loaded by the dynamic loader of the operating system.

See Also:

Large Page Support

Large page support provides a performance boost for memory-intensive database instances running on Windows Server 2003. By taking advantage of newly introduced operating system support, Oracle Database now can make more efficient use of processor memory addressing resources.

See Also:

"Support for Very Large Memory (VLM) Configurations" in Oracle Database Platform Guide for Microsoft Windows (32-Bit)

Oracle Data Provider for .NET

Oracle Data Provider for .NET (ODP.NET) 10g Release 2 (10.2) includes the following new features:

See Also:

Oracle Data Provider for .NET Developer's Guide

Oracle Enterprise Manager 10g Database Control

Oracle Enterprise Manager 10g Database Control is installed in the same Oracle home as the database and supports standalone Oracle Containers for Java (OC4J) instances.

See Also:

Oracle Home Selector

Oracle Home Selector is no longer available from the Start menu. Instead, use Oracle Universal Installer, which has functionality similar to Oracle Home Selector.

Oracle Objects for OLE

Oracle Objects for OLE (OO4O) 10g Release 2 (10.2) has the following new and updated features:

See Also:

Oracle Objects for OLE Developer's Guide

Oracle Provider for OLE DB

Oracle Provider for OLE DB 10g Release 2 (10.2) includes the following new features:

See Also:

Oracle Provider for OLE DB Developer's Guide

Oracle Scheduler

This release includes a new database scheduler, Oracle Scheduler, to provide enterprise scheduling functionality. You can use the OracleJobScheduler service to start external jobs. This service is disabled by default. To use the external jobs functionality, the administrator must set the user name and password for the user account under which this service must run, and then enable the service.

See Also:

Oracle Services for Microsoft Transaction Server

Oracle Services for Microsoft Transaction Server supports .NET transactional applications with Oracle Data Provider for .NET through the Oracle Provider for OLE DB, and ODBC.NET through the Oracle ODBC driver.

Renamed Components

The following components were renamed in this release:

Previous Name New Name
Oracle Windows Performance Monitor Oracle Counters for Windows Performance Monitor
Oracle Administration Assistant for Windows NT Oracle Administration Assistant for Windows
Oracle Demos Oracle Examples

Oracle Database 10g Release 1 (10.1) Deprecated Components

The following Oracle Database 10g Release 1 (10.1) components that were part of Oracle9i Release 2 (9.2.0) were not available for installation with Oracle Database 10g release 1 (10.1):