HOW TO USE MORE THAN TWO GB RAM FOR ORACLE IN WINDOW 32 BITS
Using AWE in Windows is relatively simple. From the Oracle 3 gig address space, we allocate space for a ‘window’ onto the whole of the db buffers.
• The size of this window is user-configurable.
• The larger the window, the more buffers are quickly available, however the larger the window, the less space there is for other memory structures like shared pool, connections, PGAs, etc.
• Set use_indirect_data_buffers=true
• Set AWE_WINDOW_SIZE in the registry to the number of bytes of address space to use for your window onto extended memory. The default is 1GB.
• Increase db_block_buffers to a higher value up to available memory
Halim is a Sr. Database Engineer/Data Architect (in Atlanta, USA) who is an Oracle certified (OCP) DBA, (OCP) Developer, Certified Cloud Architect Professional as well as OCI Autonomous DB specialist with extensive expertise in Database design, configuration, tuning, capacity planning, RAC, DG, Scripting, Python, PL/SQL etc. He achieved 16th position in worldwide first-ever PL/SQL Challenge cup playoff- http://plsql-challenge.blogspot.com/2010/07/winners-of-first-plsql-challenge.html
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
Index Usage – 21 week ago
-
-
-
-
-
-
-
-
Oracle Cloud & Third party tools3 years ago
-
-
-
Moving Sideways7 years ago
-
Upcoming Events...10 years ago
-
No comments:
Post a Comment