DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002

    windows 2000 allows usage of 8gb of physical memory.

    oracle can take advantage of this. I read across that for oracle to use > 3gb, some steps need to be performed

    1) /PAE , /3GB option need to set in boot.ini. This allows windows to see all available physical memory.

    2) oracle parameter, USER_INDIRECT_DATA_BUFFERS=TRUE

    3) key \\hkey_local_machine\software\oracle\ there might be several subdirectories HOME0, HOME1...etc. Find the oracle-home subkey for the oracle-software of the database for which you want to use >3GB of memory

    3.1) ADD the value AWE_WINDOW_MEMORY. Add it as string value. With this parmater you specify the amount of memory out of the db_block_buffers, that is allocated in the first 3GB of addressable memory

  2. #2
    Join Date
    Sep 2002
    so whats the question?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width