RE: Help with Windows error - I have this issue as well
- From: "Sweetser, Joe" <Joe.Sweetser@xxxxxxxxxxxxxxxx>
- To: <katpopins21@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 28 Jun 2006 07:51:25 -0700
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of kathy duret
Sent: Wednesday, June 28, 2006 8:15 AM
To: oracle-l@xxxxxxxxxxxxx
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>
Other related posts:
