How to use memory larger than 2 GB in Oracle Database

Server: hpdl580g2 (6 GB dual-CPU memory) win2003 Enterprise Edition + Oracle 9i 2.0.3.0

 

 

1. First, add the startup parameters 3G and PAE to boot.int.

 

 

Multi (0) disk (0) RDISK (0) Partition (1)/winnt = "Microsoft Windows 2003 Enterprise Edition"

 

 

/3g/PAE/fastdetect

 

 

 

2. Then add the string value in the registry [HKEY_LOCAL_MACHINE/software/Oracle/home0:

 

 

Awe_window_memory, set to 1G: 1024000000

 

 

 

3. Back up the currently used spfile: run the following command in cmd:

 

 

Sqlplus/nolog

 

 

Conn/As sysdba

 

 

Create pfile = 'd:/BK. ora 'from spfile;

 

 

 

4. Modify the spfile value of Oracle. When the database is opened, run the following command under sqlplus:

 

 

Alter system set use_indirect_data_buffers = true scope = spfile;

 

 

Alter system set pre_page_sga = true scope = spfile;

 

 

Alter system set db_block_buffers' = 262144 scope = spfile;

 

 

(After modification, the SGA size is db_block_size * db_block_buffers = 8 K * 256 k = 2g)

 

 

 

5. After modifying the spfile, comment out the db_cache_size parameter in the spfile.

 

 

Pilot spfile:

 

 

Create pfile = 'd:/modify. ora 'from spfile;

 

 

Then open the modify. ora file under drive D in notepad, find db_cache_size and comment it out (add the # At the beginning of the line), and import the modified pfile back to spfile;

 

 

Close the database in sqlplus and import it back to spfile:

 

 

Shutdown immediate;

 

 

Create spfile from pfile = 'd:/modify. ora ';

 

 

Exit;

 

 

 

6. Restart the operating system.

This article from: http://oracle.chinaitlab.com/induction/746059.html