{"id":17795,"date":"2019-01-23T10:04:37","date_gmt":"2019-01-23T12:04:37","guid":{"rendered":"https:\/\/orabr.com\/?p=17795"},"modified":"2019-01-23T10:04:37","modified_gmt":"2019-01-23T12:04:37","slug":"oracle-verificar-ponto-da-package-procedure-que-sendo-executado-em-execucao","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=17795","title":{"rendered":"Oracle &#8211; Verificar ponto da package\/procedure que sendo executado\/ em execu\u00e7\u00e3o"},"content":{"rendered":"<p><HTML><HTML><\/p>\n<p id=\"docs-internal-guid-28a99d8d-7fff-2d7d-9a40-17ffa774df61\" dir=\"ltr\" style=\"caret-color: #000000; color: #000000; font-family: -webkit-standard; line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; background-color: transparent; font-variant-ligatures: normal; font-variant-east-asian: normal; font-variant-position: normal; vertical-align: baseline; white-space: pre-wrap;\">SELECT *<\/span><\/p>\n<p dir=\"ltr\" style=\"caret-color: #000000; color: #000000; font-family: -webkit-standard; line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; background-color: transparent; font-variant-ligatures: normal; font-variant-east-asian: normal; font-variant-position: normal; vertical-align: baseline; white-space: pre-wrap;\"> \u00a0FROM gv$sql<\/span><\/p>\n<p dir=\"ltr\" style=\"caret-color: #000000; color: #000000; font-family: -webkit-standard; line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; background-color: transparent; font-variant-ligatures: normal; font-variant-east-asian: normal; font-variant-position: normal; vertical-align: baseline; white-space: pre-wrap;\"> where LAST_LOAD_TIME is not null<\/span><\/p>\n<p dir=\"ltr\" style=\"caret-color: #000000; color: #000000; font-family: -webkit-standard; line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; background-color: transparent; font-variant-ligatures: normal; font-variant-east-asian: normal; font-variant-position: normal; vertical-align: baseline; white-space: pre-wrap;\"> \u00a0\u00a0AND MODULE LIKE &#8216;%NOME_DA_PACKAGE OU PROCEDURE%&#8217;<\/span><\/p>\n<p dir=\"ltr\" style=\"caret-color: #000000; color: #000000; font-family: -webkit-standard; line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; background-color: transparent; font-variant-ligatures: normal; font-variant-east-asian: normal; font-variant-position: normal; vertical-align: baseline; white-space: pre-wrap;\"> \u00a0\u00a0ORDER BY LAST_LOAD_TIME DESC<\/span><\/p>\n<p><\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SELECT * \u00a0FROM gv$sql where LAST_LOAD_TIME is not null \u00a0\u00a0AND MODULE LIKE &#8216;%NOME_DA_PACKAGE OU PROCEDURE%&#8217; \u00a0\u00a0ORDER BY LAST_LOAD_TIME DESC<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29,124,126,138],"tags":[],"class_list":["post-17795","post","type-post","status-publish","format-standard","hentry","category-base-de-conhecimentos","category-database","category-developer-tools","category-sql"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/17795","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=17795"}],"version-history":[{"count":0,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/17795\/revisions"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=17795"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=17795"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=17795"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}