Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Help with Windows error - I have this issue as well
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
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of kathy duret
Sent: Wednesday, June 28, 2006 8:15 AM
To: oracle-l_at_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.
<http://us.rd.yahoo.com/mail_us/taglines/postman8/*http:/us.rd.yahoo.com
/evt=39663/*http:/voice.yahoo.com>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 28 2006 - 09:51:25 CDT
![]() |
![]() |