It gives the ratio of the total number of latch misses to the number of latch gets for all latches. If the latch hit ratio is below 99 percent, it indicates a latching problem. A latch free wait event in the Top 5 wait events section of the statspack or AWR report confirms that. You must refer to the Latch section of the report for further analysis.
Run the hitratio script to get the ratio.
Thanks
My Favourite Blogs
Visits
Archive
-
▼
2009
(120)
-
▼
July
(29)
- TkProf
- Event 10046 Tracing (Other's session)
- Event 10046 Tracing
- Event 10046 Levels
- Tracing other's session
- Tracing other's session in 10g
- Tracing own session
- Autotrace
- Hit Ratio in Oracle 10g
- Rollback Segment Wait to Get Ratio
- Database Wait Time to CPU Time Ratio
- Chained Row Ratio
- Latch Hit Ratio
- Execute to Parse Ratio
- Parse CPU to Parse Elapsed
- Soft Parse Ratio
- Pin Hit Ratio
- Get Hit Ratio
- Dictionary Cache Hit Ratio
- Library Cache Reload Ratio
- Library Cache Hit Ratio
- In (PGA) Memory Sort Ratio
- Buffer and Redo Nowait Ratio
- Buffer Cache Hit Ratio
- Hit Ratio Script
- AWR Basic Info
- Basic database Info
- DBA Views
- V$ Views
-
▼
July
(29)
Followers
Labels
- Performance Tuning
- ASM
- Hit Ratio Analysis
- Flashback Recovery
- SQL
- Wait Events
- Undo Tablespace
- 10g Features
- Errors
- Backup
- Tracing
- RAC
- Miscellaneous
- FRA
- RMAN
- Recovery
- SQL Scripts
- Temporary Tablespace
- Data Pump
- Installation
- OEM
- Parameters
- Shrink
- Utilities
- ADDM
- Architecture
- TSPITR
- Unix
- AWR
- High Availability
- Latch
- Network
- Privilege
Oracle Database Administration. Copyright 2008 All Rights Reserved Revolution Two Church theme by Brian Gardner Converted into Blogger Template by Bloganol dot com
No comments:
Post a Comment