 spfile tunning help!!! [message #152633] |
Sun, 25 December 2005 20:28  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
