(Target 100%) Buffer Nowait %: 100.00 Redo NoWait %: 100.00 Buffer Hit %: 97.95 In-memory Sort %: 100.00 Library Hit %: 89.21 Soft Parse %: 91.37 Execute to Parse %: 8.96 Latch Hit %: 100.00 Parse CPU to Parse Elapsd %: 7.06 % Non-Parse CPU: 50.82 Flash Cache Hit %: 0.00 ...
PGA Memory Advisory Snap: 70723 -> When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0 Estd Extra Estd P Estd PGA PGA Target Size W/A MB W/A MB Read/ Cache Overallo Estd Est (MB) Factr Processed Written to Disk Hit % Count...
2、buffer HIT%: 经典的经典,高速缓存命中率,反应物理读和缓存命中间的纠结,但这个指标即便99% 也不能说明物理读等待少了不合理的db_cache_size,或者是SGA自动管理ASMM /Memory 自动管理AMM下都可能因为db_cache_size过小引起大量的db file sequential /scattered read等待事件; maclean曾经遇到过因为大量硬解析导致...
100.00 buffer hit %: 97.95 in-memory sort %: 100.00 library hit %: 89.21 soft parse %: 91.37 execute to parse %: 48.96 latch hit %: 100.00 parse cpu to parse elapsd %: 47.06 % non-parse cpu: 50.82 flash cache hit %: 0.00 top 10 foreground events by total wait time event waits t...
Pool Hit % : 该缓冲池的命中率 Buffer Gets: 对该缓冲池的中块的访问次数 包括 consistent gets 和 db block gets Physical Reads: 该缓冲池Buffer Cache引起了多少物理读, 其实是physical reads cache ,单位为 块数*次数 Physical Writes :该缓冲池中Buffer cache被写的物理写, 其实是physical writes from...
• Buffer Hit%:表示进程从内存中找到数据块的比率,内存数据块命中率。 (不应低于99%) • Library Hit%:表示共享池中SQL解析的命中率。 (不应低于95%) 如果过小,说明该数据库中可能存在library cache的争用。 • Execute to Parse:是语句执行与 解析 的比例,如果要SQL重用率高,则这个比例会很高。该值...
Cache Sizes - - Load Profile Load Profile In-Memory統計が追加 Instance Efficiency Percentages Instance Efficiency Percentages 'Flash Cache Hit %'が追加 Shared Pool Statistics - - Top 5 Timed Foreground Events Top 10 Foreground Events by Total Wait Time 'Wait Avg(ms)'が小数点以下2桁まで表示 (...
OracleAWR内容详解 OracleAWR内容详解 1.AWR 报告头信息 KTDB1107793954ktdb PRIMARY EE19.0.0.0.0YES NO ktdb2202-3⽉ -20 19:35 hn-ekdb2Linux x86 64-bit80804753.98 Begin Snap:533914-5⽉ -20 08:00:03159.54 End Snap:534214-5⽉ -20 11:00:14168.64 Elapsed:180.17 (mins)DB Time...
Pool Hit % : 该缓冲池的命中率 Buffer Gets: 对该缓冲池的中块的访问次数 包括 consistent gets 和 db block gets Physical Reads: 该缓冲池Buffer Cache引起了多少物理读, 其实是physical reads cache ,单位为 块数*次数 Physical Writes :该缓冲池中Buffer cache被写的物理写, 其实是physical writes from...
Execute to Parse %: 64.36 Latch Hit %: 96.54 Parse CPU to Parse Elapsd %: 19.45 % Non-Parse CPU: 31.02Flash Cache Hit %: 0.00<snip!> Cache Sizes Begin End ~~~ --- --- Buffer Cache: 960M 960M Std Block Size: 8K Shared Pool Size: 4,096M 4,096...