Oracle Audio Technologies B10508-01 Manual Do Utilizador

Introduction to the Oracle9i 64-bit Feature

Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS

This section includes the following information:

■

■

■

The Oracle 64-bit feature provides the ability to support Very Large Memory (VLM) 
system configurations with large amounts of RAM.

The primary benefit of the 64-bit feature is "performance", because many operations 
can now run at memory speed instead of disk speed

.  

With larger amounts of data 

in memory, the database issues fewer calls to disk, thus eliminating the delay of 
disk I/O.

Oracle’s 64-bit feature also provides the advantage of "scalability", to support larger 
number of users and larger amounts of data

.  

The system does not need to swap 

data in and out of memory to process all of the transaction requests and can more 
effectively accommodate requests for larger amounts of data.

The 64-bit feature can benefit both query-intensive (DSS) and read-write (OLTP) 
transactions

.  

For DSS, the database feature provides particular advantage for index 

builds, full table scans, ad hoc queries, and multi-way joins

.  

For OLTP, the feature 

provides the ability to support very large tables, large amounts of data, and large 
numbers of users.

Starting with release 7.3.2.3.2, HP OpenVMS Alpha supported the Very Large 
Memory (VLM) 64-bit feature

.  

The HP OpenVMS Alpha operating system has 

native 64-bit memory addressing, which allows Oracle9i to implement the 64-bit 
feature

.  

The need to estimate the maximum System Global Area (SGA) at 

installation time is now eliminated and process startup times are faster

.  

The Server 

no longer includes an SGAPAD.

By default, SGA creation uses the support which first appeared in the 
HP OpenVMS Alpha version 7.1 operating system that allows the creation of global