Home » RDBMS Server » Server Administration » Increasing memory parameters and performance
Increasing memory parameters and performance [message #154743] Tue, 10 January 2006 06:49 Go to next message
vraman3
Messages: 7
Registered: January 2006
Junior Member
hi ,
i have increased my memory from 256 M to 1 gig.
i am running oracle 9i r1 on NT 4 .
how and what sort of increase in parameters (sga buffer cache,and PGA) would give me a better performance.
i am running a client server application with about 5 concurrent users. my DB size is arounf 1.5 gig

Report message to a moderator

Re: Increasing memory parameters and performance [message #154747 is a reply to message #154743] Tue, 10 January 2006 07:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Do you have a performance problem now?
How exactly?

Report message to a moderator

Re: Increasing memory parameters and performance [message #154906 is a reply to message #154743] Wed, 11 January 2006 04:36 Go to previous message
vraman3
Messages: 7
Registered: January 2006
Junior Member
the performance is generally slower (but workably slower).
now that there is an increase in the memory can i have a better overall performance by increasing the SGA/PGA.

Report message to a moderator

Previous Topic: dual processor NT server
Next Topic: running multiple sql loader runs on many datafiles
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 15:36:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.