Oracle® Database Platform Guide 10g Release 1 (10.1) for Windows Part Number B10113-02 |
|
|
View PDF |
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:
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.
See Also: "Large Page Support" |
Scheduler
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:
Job slave process (one for each job)
extjob
service (one service, with one thread for each job)
The actual external executable or job (one for each external job)
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.
Beginning with Oracle9i release 2 (9.2.0.2) for 64-bit Windows, Oracle supports 64-bit processing in the following operating systems:
Windows XP 64-bit Edition Version 2003
Windows Server 2003 for 64-bit Itanium 2 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".
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:
"Using the User Migration Utility" in Oracle Advanced Security Administrator's Guide
This section contains these topics:
Windows XP Support
Oracle9i release 1 (9.0.1.1.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
http://metalink.oracle.com/
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 Not Supported
CONNECT INTERNAL
and CONNECT INTERNAL/PASSWORD
are not supported in Oracle9i. Use the following instead:
CONNECT / AS SYSDBA 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.