Skip Headers

Oracle® Database Platform Guide
10g Release 1 (10.1) for Windows

Part Number B10113-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page
Go to next page
View PDF

What's New in Oracle Database for Windows

This section describes new features of Oracle Database and provides pointers to additional information. New features information from previous releases is also retained to help those users migrating to the current release.

The following sections describe new features:

Oracle Database 10g Release 1 (10.1) New Features

This section contains these topics:

Large Page Support

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


This release includes a new database scheduler to provide enterprise scheduling functionality. External jobs performed by the user are started using the OracleJobScheduler service. This service is disabled by default. In order to use the external jobs functionality, the administrator must set the username and password for the user account under which this service must run, and enable the service.

Restricting execution of external jobs to a low-privileged user prevents any random database user from gaining operating system level privileges, but it also places restrictions on the kinds of jobs that can be run. Jobs requiring a higher level of operating system privileges cannot be run by this mechanism.

On Windows, running an external job involves the following processes:

See Also:

Database Password Encryption

When a user attempts a remote login to Oracle Database, the password is automatically encrypted before it is sent to the remote database. For more information, see "Automatically Encrypted Database Passwords".

Data Pump Import and Export

Two new utilities offer faster transfer of files to and from Oracle Database. The older file transfer utilities, Import and Export, are retained for use with databases created with earlier versions of Oracle software. For more information on Data Pump Import and Export, see Chapter 2, "Database Tools on Windows".

Oracle Database Client Features

SQL*Plus Worksheet and Oracle Enterprise Manager Console are available only with Oracle Database Client.

Desupported Features

Migration Utility is not supported in Oracle Database 10g Release 1 (10.1). Pro*C/C++ is supported in Oracle Database 10g Release 1 (10.1), but the graphical user interface to Pro*C/C++ is not.

Oracle9i Release 2 ( New Feature

Beginning with Oracle9i release 2 ( for 64-bit Windows, Oracle supports 64-bit processing in the following operating systems:

Most of the features and functions of the 32-bit version carry over to the 64-bit version. Differences between them are noted where applicable in the text and discussed in full in Appendix G, "Oracle Database for 64-Bit Windows".

Oracle9i Release 2 (9.2) New Features

This section contains these topics:

Very Large Memory Support

Oracle9i release 2 (9.2) for Windows supports Very Large Memory (VLM) configurations in Windows 2000 and Windows XP, which allow Oracle9i release 2 (9.2) to access more than the 4 gigabyte (GB) of RAM traditionally available to Windows applications. For more information, see "Oracle Database Scalability on Windows".

User Migration Utility

A new command-line tool, User Migration Utility, simplifies conversion of local or external database users to enterprise users. For more information, see:

Oracle9i Release 1 (9.0.1) New Features

This section contains these topics:

Windows XP Support

Oracle9i release 1 ( for Windows is certified on the 32-Bit version of Windows XP Professional Edition.

Oracle provides support information for components on various platforms, lists compatible client and database versions, and identifies patches and workaround information. Find the latest certification information at

You must register online before using OracleMetaLink. After logging into OracleMetaLink, select Product Lifecycle from the left-hand column.

Database Configuration Assistant Improvements

Database Configuration Assistant has been redesigned to include database definitions saved as templates. The templates can generate databases. Users can define new templates, modify existing templates, or use the ones Oracle provides. When creating a database with Database Configuration Assistant, users can include new Sample Schemas provided by Oracle.

Oracle Internet Directory Administration Improvements

Administration of Oracle Internet Directory replication server has been improved with the addition of new replication queue management and reconciliation tools.

Using Oracle Database on Windows 2000

There are some differences between using Oracle Database on Windows 2000 and Windows NT 4.0. For more information, see Appendix E, "Using Oracle Database on Windows 2000".


CONNECT INTERNAL and CONNECT INTERNAL/PASSWORD are not supported in Oracle9i. Use the following instead:

CONNECT username/password AS SYSDBA

Server Manager Not Supported

Server Manager is not supported in Oracle9i. Use SQL*Plus instead. Most Server Manager scripts should work in a SQL*Plus environment, but some scripts may need to be modified.