{"id":77,"date":"2021-07-21T15:03:49","date_gmt":"2021-07-21T07:03:49","guid":{"rendered":"http:\/\/dba.qishuo.xin\/?p=77"},"modified":"2021-08-01T17:11:09","modified_gmt":"2021-08-01T09:11:09","slug":"oracle-awr-segments-by-row-lock-waits","status":"publish","type":"post","link":"http:\/\/dba.qishuo.xin\/?p=77","title":{"rendered":"Oracle-AWR-Segments by Row Lock Waits"},"content":{"rendered":"<p>Segments by Row Lock Waits<br \/>\n\u67e5\u8be2SQL\uff1a<\/p>\n<pre><code class=\"language-sql\">ALTER SESSION SET nls_timestamp_format=&#039;DD-MON-RR HH24:MI&#039;;\n\nSELECT P.snap_id,\n  P.begin_interval_time,\n  O.owner,\n  O.object_name,\n  O.subobject_name,\n  O.object_type,\n  S.row_lock_waits_delta\nFROM dba_hist_seg_stat S,\n  dba_hist_seg_stat_obj O,\n  dba_hist_snapshot P\nWHERE S.dbid               =O.dbid\nAND S.ts#                  =O.ts#\nAND S.obj#                 =O.obj#\nAND S.dataobj#             =O.dataobj#\nAND S.snap_id              =P.snap_id\nAND S.dbid                 =P.dbid\nAND S.instance_number      =P.instance_number\nAND S.row_lock_waits_delta &gt; 0\nAND P.snap_id BETWEEN      &lt;begin_snap&gt;  AND &lt;end_snap&gt;\nORDER BY 1,3,4;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Segments by Row Lock Wait&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,21],"tags":[],"class_list":["post-77","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/77","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=77"}],"version-history":[{"count":1,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/77\/revisions"}],"predecessor-version":[{"id":78,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/77\/revisions\/78"}],"wp:attachment":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=77"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=77"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=77"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}