Hi all!

We have Oracle v8i with NT as OS.

1.Does increasing SHARED_POOL_SIZE increases Library buffer cache as well as Data Dictionary cache!

What impact does it have on the DB.

If not,then what is the other alternative.Considering my cache buffer size is full having 24x7 db environment!

2.Does increasing INIT.ORA Parameter DB_BLOCK_LRU_EXTENDED_STATISTICS
increases library buffer cache.

Thanks&Regards,

Amitst.