Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Another Tuning Article for subheap of shared pool Oracle
  • Disbaling DBA_SCHEDULER_JOBS Oracle
  • Very clear article about oracle dataguard Oracle
  • CTAS with LONG Column for 9i and higher Oracle
  • move_arch_files.ksh Linux/Unix
  • Find Command Linux/Unix
  • FRA Information. Oracle
  • create PLAN_TABLE command. Oracle
  • Finding locked objects Oracle
  • switchover for primary database Oracle
  • SAN Linux/Unix
  • Oracle10g – Using SQLAccess Advisor (DBMS_ADVISOR) with the Automatic Workload Repository Oracle
  • Oracle 10g for solaris 10 Oracle
  • Temporary tablespace explaination Oracle
  • rm_backup_arch_file.ksh Linux/Unix

cache buffer chain latch

Posted on 19-Jan-2007 By Admin No Comments on cache buffer chain latch

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

Oracle, SQL scripts

Post navigation

Previous Post: Finding Oracle Patches with opatch
Next Post: plan10g.sql

Related Posts

  • find_open_cur.sql Find open cursorts per session Oracle
  • ORA-1841 Error Connecting to Upgraded Database After Set PASSWORD_LIFE_TIME Oracle
  • DBMS_STATS Metalinks Notes Oracle
  • Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1 Oracle
  • standard Monitoring – 1 Oracle
  • v$event_name Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Flowers Resize datafiles Oracle
  • tuning commmand for cpu, ip and memory stats Linux/Unix
  • How do I get Oracle to automatically start when my server boots up? Oracle
  • Read CSV file using PySpark Python/PySpark
  • Rename Tablespace Oracle
  • To find explain plan for a statement that occurred in past. Oracle
  • How can I tell if ASO is installed ? Oracle
  • Library cahe Latches and internal explaination Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme