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
760613
Messages: 16
Registered: March 2005
Junior Member
Hi,

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!


spfile:

testdb.__db_cache_size=562036736
testdb.__java_pool_size=8388608
testdb.__large_pool_size=4194304
testdb.__shared_pool_size=192937984
*.background_dump_dest='/u01/app/oracle/admin/testdb/bdump'
*.compatible='10.1.0.2.0'
*.control_files='/u02/oradata/testdb/control01.ctl','/u02/oradata/testdb/control02.ctl','/u02/oradata/testdb/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/testdb/cdump'
*.db_block_size=8192
*.db_domain='school.com'
*.db_file_multiblock_read_count=16
*.db_name='testdb'
*.db_recovery_file_dest='/u02/oradata/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(protocol=TCP)'
*.job_queue_processes=10
*.log_archive_dest_1='LOCATION=/u02/oradata/archive/disk1/'
*.log_archive_dest_2='LOCATION=/u02/oradata/archive/disk2/'
*.log_archive_dest_3='LOCATION=/u02/oradata/archive/disk3/'
*.log_archive_dest_4='LOCATION=/u02/oradata/archive/disk4/'
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=200
*.pga_aggregate_target=256901120
*.processes=100
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=771751936
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/testdb/udump'

Re: spfile tunning help!!! [message #152882 is a reply to message #152633] Tue, 27 December 2005 08:01 Go to previous message
smartin
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