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

http://www.peaceaday.com  

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-l