\u96a8\u624b\u8a18\u4e0b\u4f86\uff0c\u7576\u505a\u7b46\u8a18\u7528<\/p>\n
— 1. \u67e5\u8a62\u6240\u6709 session, \u78ba\u8a8d\u662f\u5426\u6709\u4eba\u4f7f\u7528\u67d0\u4e00\u500b package<\/p>\n
SELECT *\r\n FROM v$access va, v$session vs\r\n WHERE va.object = 'XXWIP_CLOT_TEMP_T'\r\n AND va.sid = vs.sid;<\/pre>\n<\/p>\n
— 2. \u67e5\u8a62\u662f\u5426\u6709\u4eba\u6b63 lock \u67d0\u4e00\u500b package<\/p>\n
SELECT * FROM sys.dba_ddl_locks WHERE NAME = 'XXINVPKG';<\/pre>\n<\/p>\n
— 3. \u67e5\u8a62\u67d0\u500b table \u662f\u5426\u88ab\u4eba lock<\/p>\n
SELECT oracle_username, os_user_name, locked_mode, object_name, object_type\r\n FROM v$locked_object a, all_objects b\r\n WHERE a.object_id = b.object_id\r\n AND object_name LIKE 'XXWIP_CLOT%';<\/pre>\n<\/p>\n
— 4. \u6240\u6709\u57f7\u884c session \u7684 sql command<\/p>\n
SELECT c.spid unix_pid, --b1,\r\n b.osuser os_user, --c1,\r\n b.username oracle_user, --c2,\r\n b.sid sid, --b2,\r\n b.serial# serial#, --b3,\r\n a.sql_text\r\n FROM v$sqltext a, v$session b, v$process c\r\n WHERE a.address = b.sql_address\r\n -- and b.status = 'ACTIVE' \r\n \/* YOU CAN CHOOSE THIS OPTION ONLY TO SEE ACTVE TRANSACTION ON THAT MOMENT *\/\r\n AND b.paddr = c.addr\r\n AND a.hash_value = b.sql_hash_value\r\n ORDER BY c.spid, a.hash_value, a.piece<\/pre>\n<\/p>\n","protected":false},"excerpt":{"rendered":"
\u96a8\u624b\u8a18\u4e0b\u4f86\uff0c\u7576\u505a\u7b46\u8a18\u7528 — 1. \u67e5\u8a62\u6240\u6709 session, \u78ba\u8a8d\u662f\u5426\u6709\u4eba\u4f7f\u7528\u67d0\u4e00\u500b packag …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[23,24],"class_list":["post-130","post","type-post","status-publish","format-standard","hentry","category-database","tag-oracle-db","tag-sql"],"_links":{"self":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/posts\/130","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=130"}],"version-history":[{"count":0,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/posts\/130\/revisions"}],"wp:attachment":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}