Oracle memory exceeds 2 GB

In. Retained for future studies. I hereby declare that the results of others do not belong to me.

Server: hpdl 580 GB 2 (Dual CPU 6g Memory) win2003 Enterprise Edition + Oracle 9i 2.0.3 . 0

1. Add the startup parameter to boot.int. 3G And PAE

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

/ 3G /PAE/fastdetect

2. Add a string value in the registry [HKEY_LOCAL_MACHINE/software/Oracle/home0:

Awe_window_memory, set 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 to complete the operation.