{"provider_name":"Hatena Blog","author_url":"https://blog.hatena.ne.jp/yohei-a/","published":"2011-11-30 18:55:51","type":"rich","blog_title":"ablog","description":"\u5b9a\u671f\u7684\uff0830\u79d2\u9593\u9694\u306a\u3069\uff09\u306b V$SYSSTAT \u306e\u60c5\u5831\u3092 sysstat.log \u306b\u51fa\u529b\u3057\u3066\u3044\u308b\u3068\u3057\u3066\u3001sysstat.log \u304b\u3089 \"global cache blocks lost\" \u306b\u3064\u3044\u3066\u3001\u6642\u7cfb\u5217\u3067\u5dee\u5206\u3092\u6c42\u3081\u305f\u3044\u3068\u3044\u3063\u305f\u3068\u304d\u306b\u4f7f\u3046 Perl \u30ef\u30f3\u30e9\u30a4\u30ca\u30fc\u3067\u3059\u3002 \u30b3\u30de\u30f3\u30c9 % perl -F, -lane '/global cache blocks lost/ and printf(qq/%s,%s\\n/,$F[0],$F[2]-$tmp) and $tmp=$F[2]' sysstat.log \u5b9f\u884c\u7d50\u679c 0904235511,0 0904235541,1 0904235611,0 09\u2026","image_url":null,"url":"https://yohei-a.hatenablog.jp/entry/20111130/1322646951","version":"1.0","categories":["Oracle","null"],"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fyohei-a.hatenablog.jp%2Fentry%2F20111130%2F1322646951\" title=\"V$SYSSTAT \u304b\u3089\u7279\u5b9a\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u7d71\u8a08\u60c5\u5831\u306e\u5dee\u5206\u3092\u51fa\u3059 Perl \u30ef\u30f3\u30e9\u30a4\u30ca\u30fc - ablog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_url":"https://yohei-a.hatenablog.jp/","width":"100%","provider_url":"https://hatena.blog","author_name":"yohei-a","title":"V$SYSSTAT \u304b\u3089\u7279\u5b9a\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u7d71\u8a08\u60c5\u5831\u306e\u5dee\u5206\u3092\u51fa\u3059 Perl \u30ef\u30f3\u30e9\u30a4\u30ca\u30fc","height":"190"}