{"id":205,"date":"2011-10-14T23:22:13","date_gmt":"2011-10-14T15:22:13","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=205"},"modified":"2011-10-15T03:23:28","modified_gmt":"2011-10-14T19:23:28","slug":"oem%e6%a8%a1%e5%9d%97%e5%ae%a1%e8%ae%a1%e6%9f%a5%e8%af%a2%e8%af%ad%e5%8f%a5%e5%8d%a0%e7%94%a8%e8%be%83%e5%a4%a7%e8%b5%84%e6%ba%90","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=205","title":{"rendered":"OEM\u6a21\u5757\u5ba1\u8ba1\u67e5\u8be2\u8bed\u53e5\u5360\u7528\u8f83\u5927\u8d44\u6e90"},"content":{"rendered":"

\u53d1\u73b0\u4e00\u4e2a\u5bfc\u81f4Oracle\u81ea\u5df1\u7684\u4f4e\u6548SQL\uff0c\u5728AWR\u62a5\u544a\u4e2d\u5360\u7528\u8f83\u5927\u7684\u8d44\u6e90\u3002<\/p>\n

\u8fd9\u4e2aSQL\u5728Elapsed Time\u3001CPU Time\u3001User I\/O Wait Time\u3001Buffer Gets\u3001Physical Reads\u90fd\u4f1a\u51fa\u73b0\uff0c\u5176SQL\u6a21\u5757\u662fOracle Enterprise Manager.Metric Engine\u3002\u663e\u7136\u8fd9\u662f\u4e00\u4e2aOEM\u81ea\u5df1\u7684SQL\uff0c\u68c0\u67e5\u5b8c\u6574SQL\u8bed\u53e5\uff1a<\/p>\n

<pre lang=’SQL’>SELECT TO_CHAR(current_timestamp AT TIME ZONE ‘GMT’, ‘YYYY-MM-DD
\nHH24:MI:SS TZD’) AS curr_timestamp, COUNT(username) AS failed_count FROM
\nsys.dba_audit_session WHERE returncode != 0 AND TO_CHAR(timestamp, ‘YYYY-MM-DD
\nHH24:MI:SS’) >= TO_CHAR(current_timestamp – TO_DSINTERVAL(‘0 0:30:00’),
\n‘YYYY-MM-DD HH24:MI:SS’)<\/pre><\/p>\n

\u8fd9\u4e2a\u68c0\u67e5DBA_AUDIT_SESSION\u7684SQL\u8bed\u53e5\u5199\u6cd5\u5f88\u70c2\uff0c\u4ee5\u81f4\u4e8e\u4e00\u5f00\u59cb\u6211\u8fd8\u4e0d\u592a\u76f8\u4fe1\u662f\u51fa\u81eaOracle\uff0c\u4e0d\u8fc7Oracle Enterprise Manager.Metric Engine\u7684MODULE
\nNAME\u5df2\u7ecf\u8bf4\u660e\u4e86\u95ee\u9898\uff0cOracle\u5c45\u7136\u81ea\u5df1\u8fdd\u53cd\u5bf9\u5217\u8fdb\u884c\u64cd\u4f5c\u4ee5\u53ca\u4e0d\u5fc5\u8981\u7684\u8f6c\u6362\u539f\u5219\u3002<\/p>\n

\u6b64\u5916\uff0c\u8fd9\u4e2aSQL\u57fa\u672c\u4e0a\u6ca1\u6709\u529e\u6cd5\u4f7f\u7528\u7d22\u5f15\uff0c\u5982\u679cDBA_AUDIT_SESSION\u4e2d\u8bb0\u5f55\u5f88\u591a\uff0c\u90a3\u4e48\u8fd9\u4e2aSQL\u4f1a\u975e\u5e38\u8017\u65f6\uff0c\u8fd9\u5c31\u662f\u4e0d\u7b97\u662fOEM\u7684bug\uff0c\u81f3\u5c11\u4e5f\u662f\u4e00\u79cd\u8bbe\u8ba1\u7f3a\u9677\u3002<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

\u53d1\u73b0\u4e00\u4e2a\u5bfc\u81f4Oracle\u81ea\u5df1\u7684\u4f4e\u6548SQL\uff0c\u5728AWR\u62a5\u544a\u4e2d\u5360\u7528\u8f83\u5927\u7684\u8d44\u6e90\u3002 \u8fd9\u4e2aSQL\u5728Elapsed Time\u3001CPU Time\u3001User I\/O Wait Time\u3001Buffer Gets\u3001Physical Reads\u90fd\u4f1a\u51fa\u73b0\uff0c\u5176SQL\u6a21\u5757\u662fOracle Enterprise Manager.Metric Engine\u3002\u663e\u7136\u8fd9\u662f\u4e00\u4e2aOEM\u81ea\u5df1\u7684SQL\uff0c\u68c0\u67e5\u5b8c\u6574SQL\u8bed\u53e5\uff1a <pre lang=’SQL’>SELECT TO_CHAR(current_timestamp AT TIME ZONE ‘GMT’, ‘YYYY-MM-DD HH24:MI:SS TZD’) AS curr_timestamp, COUNT(username) AS failed_count FROM sys.dba_audit_session WHERE returncode != 0 AND TO_CHAR(timestamp, ‘YYYY-MM-DD HH24:MI:SS’) >= TO_CHAR(current_timestamp – … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[145,144,143],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-3j","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/205"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=205"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/205\/revisions"}],"predecessor-version":[{"id":206,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/205\/revisions\/206"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=205"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=205"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}