shared pool [message #65321] |
Mon, 02 August 2004 03:55 |
p anil kumar
Messages: 3 Registered: July 2004
|
Junior Member |
|
|
i increased the size my db_block_buffer in the database
but i noticed that my performance of shared pool degraded immediately. is it necessary to increase the
shared pool size if we increase db_block_buffer size
how are they related ?
|
|
|
Re: shared pool [message #65322 is a reply to message #65321] |
Tue, 03 August 2004 01:52 |
Satheesh Babu.S
Messages: 35 Registered: July 2004
|
Member |
|
|
Hi,
for every 4 data buffers there will be 1k overhead. But i don't think that will have such a impact. What for your system is waiting. You can trace the system and find out where you system is waiting.
Thanks and Regards,
Satheesh Babu.S
|
|
|