Couple o’ things. First, the
AWE/PAE/etc stuff only allows you to move db_block_buffers/data buffers above
and beyond the 3gb limit. If that’s not the part of the SGA you
want to grow, it won’t help. I’m sure you’ve read it,
but Metalink Note:225349.1 speaks to this. Second, the only way I found
to verify the extra memory (beyond the default 2gb) was, indeed, being
allocated was to use Task Manager. In the Process tab, do View >
Select Columns and check Virtual Memory Size. Sort by this VM Size column
and you should see the size of the oracle.exe process approach the 3gb limit as
the database gets busy. I never found a way to verify the additional data
buffers outside of the SGA. The Thread Count column is interesting, too,
because it can show the approximate number of connections to the database.
But keep in mind that just starting a database under Windows will take
somewhere around 6-12 threads based on options selected in the database.
hth,
-joe
http://www.peaceaday.com
From:
oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of kathy duret
Sent: Wednesday, June 28, 2006
8:15 AM
To: oracle-l@freelists.org
Subject: RE: Help with Windows
error - I have this issue as well
The license limit looks like what I have been having issues with during
month end. How do we go about "fixing" this lovely windows
license limit issue. I believe we have purchased more than this, I am
confirming with the admin now.
Also, I have put the 3G and PAE switches into place and the init.ora
changes, but how do I test that I have it set correctly and am getting the
extra memory... I haven't seen any articles on how to test this out. (I
would love to get off windows but the 3rd party app is only supported on
windows - god help me).
Thank,
Kathy Duret
How low will we go? Check out Yahoo! Messenger’s low PC-to-Phone
call rates.