Home » RDBMS Server » Performance Tuning » spfile tunning help!!!
icon5.gif  spfile tunning help!!! [message #152633] Sun, 25 December 2005 20:28 Go to next message
Messages: 16
Registered: March 2005
Junior Member

I've just setup a test-database (oracle10g standard) and am about to do some tests.
I will do some benchmarks, and here I need your help to advice on my spfile settings.

The testdb is running on a Solaris 10 x86.
No other applications beside Oracle is running, and it is equiped with:
2.8 GHz Xeon CPU and 2GB Memory.

I want to use the maximum resources (cpu/memory) for this Oracle instance.

Please advice,

Thank you!



Re: spfile tunning help!!! [message #152882 is a reply to message #152633] Tue, 27 December 2005 08:01 Go to previous message
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
You are probably fine, depends on what you are trying to do though. Your sga target might be a bit on the high side, might want to reduce it by 256MB and increase pga target by 256MB.

But many params, especially in the newer versions and for a testing database, are fine with the defaults, and it is just a matter of you tweaking them as the need arises.

Your workarea size policy is set to auto right?

And undo management also auto?

I like to pre page, and lock, my sga.

And if you are just downloading and testing, almost might as well go with 10gR2 instead of 10gR1.
Previous Topic: Interview Qstns
Next Topic: Diff Between Utlxplp.sql and Utlxpls.sql Scripts
Goto Forum:

Current Time: Fri Dec 09 13:36:03 CST 2022