Introduction to the oracle9i 64-bit feature, Introducing the oracle9i 64-bit feature, Benefits of the oracle9i 64-bit feature – Oracle Audio Technologies ORACLE9I B10508-01 User Manual
Page 134: Introduction to the oracle9, Introducing the oracle9, Benefits of the oracle9, Introduction to the oracle9 i 64-bit feature, Introducing the oracle9 i 64-bit feature, Benefits of the oracle9 i 64-bit feature
Introduction to the Oracle9i 64-bit Feature
B-2
Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS
Introduction to the Oracle9i 64-bit Feature
This section includes the following information:
■
Introducing the Oracle9i 64-bit Feature
■
Benefits of the Oracle9i 64-bit Feature
■
Implementation of the Oracle 64-bit Feature on HP OpenVMS Alpha
Introducing the Oracle9i 64-bit Feature
The Oracle 64-bit feature provides the ability to support Very Large Memory (VLM)
system configurations with large amounts of RAM.
Benefits of the Oracle9i 64-bit Feature
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.
Implementation of the Oracle 64-bit Feature on HP OpenVMS Alpha
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