Re: Oracle 10g on Windows 2003 x64 Memory Useage

On Aug 2, 6:22 am, sev...@xxxxxxxxxx wrote:
Hi All,

We are running Oracle 10g on a Quad Dual Core Windows 2003 x64
Enterprise Server with 16GB of memory. I notice that the Oracle
process is only using 4.6 GB of Physical RAM and 10GB of Virtual
memory. Performance monitor is showing that the server has 8GB
Physical Memory free. This seems like oracle isn't using the free
memory very efficiently and swapping a lot out to disk, is this
something that can be tuned to boost performance or is it dynamically
performed by the Oracle process?

Thanks for your help, I'm new to Oracle having worked mainly with MS
SQL so go easy on me,

Regards,

Stephen

metalink 657456.992 seems to show your problem exactly. Says "What I
did find though, is whomever setup the Windows server set it up as a
File Server. I removed that option and now my Oracle process is using
6 gigs of memory (5 for SGA, 500 megs for PGA and then some over
head) ...My Page File Usage% is now at 1%."

Whatever that means. What didn't work for the guy was
http://download-west.oracle.com/docs/cd/B14117_01/win.101/b10113/ap_64bit.htm#CHDGFJJD
which tells how to grant the privilege to lock things in memory, so
I'm wondering if the real solution was something else that guy did
while fiddling about.

Since I'm a unix bigot, this is all just academic entertainment for
me.

To find the referenced document in metalink, log in there and click on
Advanced Search, and put 657456.992 in the document id box.

jg
--
@home.com is bogus.
http://www.ossec.net/en/attacking-loganalysis.html#denyhosts

.

Relevant Pages

  • [HPADM] Summary: vmunix: file: table is full & oracle client ORA-12500: TNS:listener failed
    ... Oracle, we never have this issue as the settings closely ... NFILE should be changed to 5000, ... 4Gb memory and he ever encounter a case on this server that if these are ...
    (HP-UX-Admin)
  • 64-bit: Memory issue with Oracle Provider for OLE DB
    ... When executing "SELECT INTO" queries from linked Oracle servers using the ... Is there a OLE DB Provider for Windows 2003 ... Datacentre Server 64-bit ia64? ... Is there a fix for the memory leak on the ...
    (microsoft.public.data.oledb)
  • Re: tag Thre poolmon
    ... Oracle Release 10.2.0.1.0 is the memory leaker! ... I notice that each time I called the SQL Loader the 'Thre'tag ... I will carry on my "Yet another day in the life of a memory leak ... I still did not found the solution for my server. ...
    (microsoft.public.windows.server.general)
  • [Full-disclosure] Oracle TNS Listener DoS and/or remote memory inspection
    ... Oracle TNS Listener DoS and/or remote memory inspection ... The TNS Listener can be crashed by an attacker causing a Denial of Service; ... Oracle was alerted to this flaw on the 22nd of June 2006. ... The views expressed in this email do not necessarily reflect NGS policy. ...
    (Full-Disclosure)
  • Oracle TNS Listener DoS and/or remote memory inspection
    ... Oracle TNS Listener DoS and/or remote memory inspection ... The TNS Listener can be crashed by an attacker causing a Denial of Service; ... Oracle was alerted to this flaw on the 22nd of June 2006. ... The views expressed in this email do not necessarily reflect NGS policy. ...
    (Bugtraq)