Oracle and PageFile V.S. Physical Mem

Oracle and PageFile V.S. Physical Mem

 

  

Hello All,

I have edited the boot.ini to include /PAE /3GB and increased the
sga_max_size parameter to about 2.8 GB (Actual SGA params [shared_pool,
large_pool, java_pool = arround 2.7 GB total). When I start the
database, memory is allocated from the page file (not the physical
memory which has been increased to 12 GB from 4 GB).

Can anyone tell me why Oracle is not allocating physical memory?

Oracle 9.2.0.7 Enterprise
Windowns 2003 Server Enterprise

Thank you,

Martin


------------------------------------------------------------------------------
This message is intended only for the personal and confidential use of the designated recipient(s) named. If you are not the intended recipient of this message, you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited. This communication is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product, an official confirmation of any transaction, or as an official statement of Aurora Loan Services. Email transmission cannot be guaranteed to be secure or error-free. Therefore, we do not represent that this information is complete or accurate and it should not be relied upon as such. All information is subject to change without notice.


Oracle LazyDBA home page