473,320 Members | 1,846 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Oracle on NT4 memory use

We upgraded a server from 512MB to 2.5GB due to performance issues. The
server still uses ca. 512MB of physical memory. The total commit charge is
1.8GB. Physical Memory available is about 2GB.

I've read about NT's 2GB/2GB problem, but I am not sure whether that is the
cause.

The main problem are most likely inefficient queries, but I would like to
maximize Oracle's memory use in the mean time. If I see 2GB of RAM free, I
would like to put them to use.

Any ideas?

Thanks,

Holger

Jul 19 '05 #1
3 2709
"Holger Knust" <kn****@bellsouth.net> wrote in message news:<TZ*****************@fe02.atl2.webusenet.com> ...
We upgraded a server from 512MB to 2.5GB due to performance issues. The
server still uses ca. 512MB of physical memory. The total commit charge is
1.8GB. Physical Memory available is about 2GB.

I've read about NT's 2GB/2GB problem, but I am not sure whether that is the
cause.

The main problem are most likely inefficient queries, but I would like to
maximize Oracle's memory use in the mean time. If I see 2GB of RAM free, I
would like to put them to use.

Any ideas?

Thanks,

Holger

You won't be able to use the 2G. By design NT uses 50 percent of the
memory for O/S purposes. Hence Oracle recommends to use only 1/3 of
physical memory for the SGA. See the relevant documents on NT
architecture on Metalink.
You should address the root cause instead of fighting symptoms.
Generally speaking increasing the size of the SGA also increases
paging and swapping. All Oracle hitratio's 99 percent and your OS will
be suffocating.

Sybrand Bakker
Senior Oracle DBA
Jul 19 '05 #2
My next question would be: SGA 1/3 of the physical memory available (2.5GB)
or 1/3 of 500MB that NT leaves to apps?

I will go after the queries but that will take some time.

Thanks,

Holger

<sy******@yahoo.com> wrote in message
news:a1*************************@posting.google.co m...
"Holger Knust" <kn****@bellsouth.net> wrote in message

news:<TZ*****************@fe02.atl2.webusenet.com> ...
We upgraded a server from 512MB to 2.5GB due to performance issues. The
server still uses ca. 512MB of physical memory. The total commit charge is 1.8GB. Physical Memory available is about 2GB.

I've read about NT's 2GB/2GB problem, but I am not sure whether that is the cause.

The main problem are most likely inefficient queries, but I would like to maximize Oracle's memory use in the mean time. If I see 2GB of RAM free, I would like to put them to use.

Any ideas?

Thanks,

Holger

You won't be able to use the 2G. By design NT uses 50 percent of the
memory for O/S purposes. Hence Oracle recommends to use only 1/3 of
physical memory for the SGA. See the relevant documents on NT
architecture on Metalink.
You should address the root cause instead of fighting symptoms.
Generally speaking increasing the size of the SGA also increases
paging and swapping. All Oracle hitratio's 99 percent and your OS will
be suffocating.

Sybrand Bakker
Senior Oracle DBA


Jul 19 '05 #3
"Holger Knust" <kn****@bellsouth.net> wrote in message news:<Wz*****************@fe03.atl2.webusenet.com> ...
My next question would be: SGA 1/3 of the physical memory available (2.5GB)
or 1/3 of 500MB that NT leaves to apps?
That sounds very weird. You sure you tuned NT for application server?
Looks like you left it at file server, then it uses up as much
mem as it can for file cache. You running Server, aren't you?
Not Workstation! And SP6?
You should have a LOT more than 500Mb free to apps in app server
mode.

I will go after the queries but that will take some time.

Good luck.
Cheers
Nuno Souto
wi*******@yahoo.com.au.nospam
Jul 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: atalukdar1 | last post by:
Hi , I am facing performance problem in oracle , my oracle8.1.6 in solaris 8 consume 89 to 91% memory when i see from prstat -t command, can anybody help me out to do some tuning so that i...
7
by: NTidd | last post by:
Since we have upgraded to oracle 9i every day or so we have to go in and shutdown oracle and restart it, here is what we do: sqlplus /nolog connect sys as sysdba password: connected to an idle...
0
by: Subhodini Fernandes | last post by:
We have a couple of Oracle (8.x and 9.x) install on Sun Solaris platforms. On most of the servers we have a very strange problem 1. When Oracle is started in the morning, memory usage is very...
14
by: Ruth | last post by:
Hi All I am not a DBA, but a unix administrator. After our DBA's upgraded from oracle 8.0.5 to oracle 8.1.7.4 on our test server, we have noticed a big slow down in our application...
13
by: Chris Botha | last post by:
The machine is running XP Pro with all the latest service packs, etc. I must access an Oracle database so I installed the Oracle client stuff. I can query Oracle from a Windows app, no problem....
1
by: ori | last post by:
Hi, I have an ASP.Net application hosted in a windows server 2003 (IIS 6.0). The application uses a Oracle Database to retrieve some data through an Oledb connection. I've set the IIS...
2
by: JoeUK | last post by:
I'm running Windows XP Service pack 2 I have 1GB of RAM I have an AMD 64 processor 3000+ I'm a back end oracle programmer by trade with commercial experience of 8i. I'm trying to get myself...
0
by: anneeny | last post by:
Hi there... My company has implemented Oracle Financials and Project applications in 1999 as a part of Y2K project. Oracle 11.0.3 Applications are implemented in 3-tier configuration as per the...
3
by: Holger Knust | last post by:
We upgraded a server from 512MB to 2.5GB due to performance issues. The server still uses ca. 512MB of physical memory. The total commit charge is 1.8GB. Physical Memory available is about 2GB. ...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.