This ratio indicates the percentage of parses that were soft.
Soft-Parse Ratio = 100 * Soft Parse/(Hard + Soft Parse)
If the ratio is low, that is less than 80%, then set CURSOR_SHARING init parameter to FORCE.
Run 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