How to use memory exceeding 1.7G for ORACLE 10G

If your ORACLE version is 32-bit, you can use less than GB of memory without some configuration.

A software system in the company two days ago needs to be configured in such an environment. For ORACLE's so-called masters like me, I am a little overwhelmed and even have to deal with it with my head,
This is the first job to be received by a new company. It must be done. Otherwise, the oracle dba has a virtual name. So I searched the article online immediately, but most of them were the same,
It also targets ORACLE9I. During my experiment, I also mixed up the customer's environment. However, after more than one day of hard work, we were able to figure it out.

Software environment:
Oracle 10.2.0.1
OS: Windows 2003 Server SP2 32bit

Hardware environment:
Memory: 4 GB
CPU: Intel Core (TM) 2 6300 1.86 Ghz

This environment is very important, especially for the ORACLE version. It must be different from the ORACLE9i configuration.

1) AWE is configured in the operating system, mainly to modify the boot. ini file.

Right-click "my computer", select "properties" --> Advanced tab, find "Start and fault recovery", click "set", and then click "edit ",

Add the/PAE option. The modified file is as follows:
[Boot loader]
Timeout = 30
Default = multi (0) disk (0) rdisk (0) partition (2) \ WINDOWS
[Operating systems]
Multi (0) disk (0) rdisk (0) partition (2) \ WINDOWS = "Windows Server 2003, Enterprise"/noexecute = optout/fastdetect/Pae
Multi (0) disk (0) rdisk (0) partition (1) \ WINDOWS = "Microsoft Windows XP Professional"/fastdetect/NoExecute = OptIn

2) configure the memory available for oracle and modify the registry.
Find the ORACLE Registry key HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE \ KEY_OraDb10g_home1, and KEY_OraDb10g_home1 is not the name on your machine,
Add a string value item: AWE_WINDOW_MEMORY. This value is the maximum memory size (in bytes) You want to allocate to the database. For example, if you want to allocate 4 GB of memory, the value is
4*1024*1024*1024

3) obtain the Editable ORACLE initialization parameter file
Windows Command Line

Sqlplus "/as sysdba" REM (add the current user to the ora_dba group if the login fails)

SQLPLUS> create pfile = 'initialize the parameter file' from spfile

SQLPLUS> Shutdown immediate

SQLPLUS> exit

4) edit the ORACLE initialization parameter file
Please use Ulatra editor (of course other options are acceptable, but do not use Notepad) to open the initialization parameter file generated in step 3 (it is best to back up it, in this case, the initial file can be used for startup when an error occurs)

First, unregister the following lines:
Sga_max_size
Sga_target
DB_CACHE_SIZE

Modify or add the following parameters
*. Db_block_buffers = 262144 # equal to the original DB_CACHE_SIZE/db_block_size. For example, if you want the size of DB_CACHE_SIZE to be 2 GB, the value is 2*1024*1024 K/8 K = 262144.
*. SHARED_POOL_SIZE = 419430400 #400 M in bytes (this parameter is set to report an error because the oracle awe configuration is not for him)
*. Log_buffer = 73400320 #70 M in bytes (this parameter is set to report an error because the oracle awe configuration is not specific to it)
*. Use_indirect_data_buffers = true # This parameter indicates that DB_CACHE_SIZE is calculated by setting db_block_buffers.

 

5) Start ORACLE and recreate spfile.
Run the following command in Windows:
Sqlplus "/as sysdba"
SQLPLUS> Startup pfile = 'path of the initialized parameter file modified in Step 4'
SQLPLUS> Create Spfile from pfile = 'path of the initialized parameter file modified in Step 4 '# You will find that a file SPFILEOracleSID. ORA is generated in your oracle home/Database directory.
SQLPLUS> Shutdown immediate

6) copy the file oracle home/Database/SPFILEOracleSID. ORA generated in step 3 to oracle home/dbs.

The purpose of the previous two steps is to restore the default method of starting the database using the spfile parameter file. Otherwise, your settings will be invalid.

7) Restart Oracle
Windows Command Line
Sqlplus "/as sysdba"
SQLPLUS> Startup