| Urgent! Increase memory. [message #56282] |
Mon, 17 March 2003 03:40  |
Nota
Messages: 2
Registered: April 2000
|
Junior Member |
|
|
Urgent!!!
Which parameters should I change, in order to impove the performance of a database, if I increase the RAM of the PC from 256MG to 2GB. Thank you in advance.
|
|
|
|
| Re: Urgent! Increase memory. [message #56285 is a reply to message #56282] |
Mon, 17 March 2003 04:22  |
rudi
Messages: 8
Registered: March 2003
|
Junior Member |
|
|
db_block_buffers (if buffer cache hit rate is poor),
sort_area_size
shared_pool
...
basically it depends on many influences and the problems you actually have.
Perhaps the bottleneck is the i/o-system or the application....
you have to document your changes so you can undo the changes you made when there is no success
rudi
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
