{"id":2317,"date":"2022-11-17T15:00:05","date_gmt":"2022-11-17T14:00:05","guid":{"rendered":"http:\/\/clemente.pamplona.name\/dba\/?p=2317"},"modified":"2022-11-17T15:00:47","modified_gmt":"2022-11-17T14:00:47","slug":"bucle-sleep-en-codigo-pl-sql","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/bucle-sleep-en-codigo-pl-sql\/","title":{"rendered":"Bucle sleep en codigo PL-SQL"},"content":{"rendered":"<p>Vamos a ver una entrada rapidisima y sencillisima para dummies.<\/p>\n<h1> Como introducimos una espera en codigo PL-SQL <\/h1>\n<p>La respuesta es sencillisima, con la funcion <i>DBMS_LOCK.SLEEP<\/i><br \/>\nVeamos por ejemplo como forzar dos esperas de 1 minuto para obtener un hang analyzer <\/p>\n<pre>\r\n$ORACLE_HOME\/bin\/sqlplus -s \"\/as sysdba\" << EOF\r\noradebug setmypid;\r\noradebug unlimit;\r\noradebug hanganalyze 3;\r\nexec dbms_lock.sleep(60);\r\n-- Wait upto 1 minute before getting the second hanganalyze\r\noradebug hanganalyze 3;\r\n-- Wait upto 1 minute before getting the second hanganalyze\r\nexec dbms_lock.sleep(60);\r\noradebug hanganalyze 3;\r\noradebug tracefile_name;\r\nEOF\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Vamos a ver una entrada rapidisima y sencillisima para dummies. Como introducimos una espera en codigo PL-SQL La respuesta es sencillisima, con la funcion DBMS_LOCK.SLEEP Veamos por ejemplo como forzar dos esperas de 1 minuto para obtener un hang analyzer &hellip; <a href=\"http:\/\/clemente.pamplona.name\/dba\/bucle-sleep-en-codigo-pl-sql\/\">Sigue leyendo <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,565,60,567,921,975,9,114],"tags":[1027,1028,1029,1030],"class_list":["post-2317","post","type-post","status-publish","format-standard","hentry","category-11g","category-11g-en","category-12c","category-12c-en","category-18c","category-19c","category-dummie","category-plsql","tag-hang","tag-hanganalyze","tag-oradebug","tag-sleep"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2317","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/comments?post=2317"}],"version-history":[{"count":2,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2317\/revisions"}],"predecessor-version":[{"id":2319,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2317\/revisions\/2319"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=2317"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=2317"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=2317"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}