Good Docs.
(1) http://www.oracle-training.cc/oracle_tips_hidden_parameters.htm
(2) FOR EAAPPPROD22 (UOCQA)
======================
Also I did some research on ‘cache buffer chains’ CBC events and found that wait on UOCQA instance ( on eaappprod22 ) was occurring due to wait on specific chain, not because of wait on specific Block or ROW. As per current configuration, # of linked-list chain in DB cache is “_db_block_hash_buckets”, that is 524288.
and # of latches that are controlling this group of chains are 2048. So One latch is handling 256 linked list chains. I think this is causing this “latch: cache buffer chains” latch contention.
If you permit me to change this parameter “_db_block_hash_latches” to 8192, I would like to do that and see the oracle behavior.
Please correct me if I am wrong.
(3) http://www.ixora.com.au/q+a/library.htm
(4) http://www.freelists.org/archives/oracle-l/02-2004/msg01344.html