{"id":508,"date":"2013-09-04T19:34:03","date_gmt":"2013-09-04T19:34:03","guid":{"rendered":"http:\/\/www.alemdopeoplebooks.com.br\/site\/?p=508"},"modified":"2013-10-03T17:14:18","modified_gmt":"2013-10-03T17:14:18","slug":"locks-no-oracle","status":"publish","type":"post","link":"https:\/\/www.alemdopeoplebooks.com.br\/site\/locks-no-oracle\/","title":{"rendered":"Locks no Oracle"},"content":{"rendered":"<p><a href=\"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-content\/uploads\/2013\/09\/oracle_lock.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-537 alignleft\" alt=\"oracle_lock\" src=\"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-content\/uploads\/2013\/09\/oracle_lock.jpg\" width=\"128\" height=\"120\" \/><\/a>\u00a0Se voc\u00ea esta em duvida se existe algum objeto bloqueado o select abaixo mostra os locks do banco:<\/p>\n<p>SELECT c.owner, c.object_name, c.object_type, b.SID, b.serial#, b.status,<br \/>\nb.osuser, b.machine<br \/>\nFROM v$locked_object a, v$session b, dba_objects c<br \/>\nWHERE b.SID = a.session_id AND a.object_id = c.object_id;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0Se voc\u00ea esta em duvida se existe algum objeto bloqueado o select abaixo mostra os locks do banco: SELECT c.owner,<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[79,69],"tags":[75,76],"class_list":["post-508","post","type-post","status-publish","format-standard","hentry","category-bancodedados","category-peoplesoft","tag-locks","tag-objetos-bloqueados"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/posts\/508","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/comments?post=508"}],"version-history":[{"count":2,"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/posts\/508\/revisions"}],"predecessor-version":[{"id":538,"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/posts\/508\/revisions\/538"}],"wp:attachment":[{"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/media?parent=508"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/categories?post=508"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/tags?post=508"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}