Home » RDBMS Server » Performance Tuning » shared pool
shared pool [message #65321] Mon, 02 August 2004 03:55 Go to next message
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 Go to previous message
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
Previous Topic: temporary tablespace
Next Topic: full table scan
Goto Forum:
  


Current Time: Thu Mar 28 15:06:50 CDT 2024