Monday, September 14, 2015

Parse CPU to Parse Elapsd % : which value is good ?

Low Value for this ratio is an indicator of latching problem. Investigate the Latch Sections in AWR and Statspack report for contention on library cache and shared pool latches.

Ideally Parse Elapsed must be equal to Parse CPU, i.e., only CPU time is used for parsing. In that case the ratio is 100%. If wait time is more then the ratio will be less.

Source : https://blogs.oracle.com/myoraclediary/entry/what_is_parse_cpu_to

1 comment:

  1. How to get to Casino William Hill by Bus from Kambi - Kambi Hub
    With this guide you can get to 파주 출장마사지 the 당진 출장샵 casino by Bus via Kambi, 김포 출장안마 providing you with 천안 출장마사지 your first deposit and the maximum cashouts. The 의정부 출장안마

    ReplyDelete