DB Initialisation Parameters Files [message #61144] |
Wed, 31 March 2004 19:03 |
meena
Messages: 36 Registered: December 2000
|
Member |
|
|
We have installed two databases on the same machine at client site. Onbe database is used for UAT purpose and another for parallel run. UAT database is having default init parameters. While inn the parallel database following two parameters has been chnaged by the administrator of clint. The performance of the parallel databse is very slow comparative to the UAT database. Can you let us know whether the following two parameters are having any effect on the performance. If not then what can be the most probable reason.
For your reference.
db_block_buffers
sort_area_size
The default parameter values were
<COLGROUP>
<COL style="WIDTH: 48pt" span=3 width=64>
- db_block_buffers = 32000 -
- -
- -
- -
-
sort_area_size = 65536
and changed values are as follows
<COLGROUP>
<COL style="WIDTH: 125pt; mso-width-source: userset; mso-width-alt: 6107" width=167>
- db_block_buffers = 64000 -
- -
- sort_area_size = 33554432 -
-
|
|
|
Re: DB Initialisation Parameters Files [message #61158 is a reply to message #61144] |
Thu, 01 April 2004 08:10 |
Thiru
Messages: 1089 Registered: May 2002
|
Senior Member |
|
|
Sure those two can affect performance! Your sort_area_size (32M) seems to be very high. Note this is allocated per session and not for the whole instance. Try reducing that to 1M or 2M . Maybe db_block_buffers too(you are doubling!)
When you overallocate SGA/PGA size, you are starving the system of memory forcing to page/swap that could affect performance drastically.
BTW, what made him/her increase the cache/sort area so much?
-Thiru
|
|
|
|