{"id":1672,"date":"2017-07-24T21:48:16","date_gmt":"2017-07-24T19:48:16","guid":{"rendered":"http:\/\/clemente.pamplona.name\/dba\/?p=1672"},"modified":"2017-08-11T11:28:55","modified_gmt":"2017-08-11T09:28:55","slug":"evento-de-espera-enq-hw","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/evento-de-espera-enq-hw\/","title":{"rendered":"Evento de espera  \t enq: HW"},"content":{"rendered":"<p>Hoy vamos a ver un tipo de evento relaccionado habitualmente con las inserciones. <\/p>\n<p>El <em> HW High Water enqueue <\/em> enq: HW se da cuando varios procesos compiten para aumentar el high water mark de una tabla .<\/p>\n<p>Si disponemos del Enterprise manager console, podremos ver como aparece claramente un area marron de <em>configuracion.<\/em><\/p>\n<p><a href=\"http:\/\/clemente.pamplona.name\/dba\/evento-de-espera-enq-hw\/marron\/\" rel=\"attachment wp-att-1673\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/clemente.pamplona.name\/dba\/wp-content\/uploads\/2017\/08\/marron.jpg\" alt=\"\" width=\"676\" height=\"217\" class=\"aligncenter size-full wp-image-1673\" \/><\/a><\/p>\n<p>Esta carga se asocia claramente a una consulta de insert<\/p>\n<p><a href=\"http:\/\/clemente.pamplona.name\/dba\/evento-de-espera-enq-hw\/insert\/\" rel=\"attachment wp-att-1674\"><img loading=\"lazy\" decoding=\"async\" width=\"892\" height=\"33\" src=\"http:\/\/clemente.pamplona.name\/dba\/wp-content\/uploads\/2017\/08\/insert.jpg\" class=\"aligncenter size-full wp-image-1674\" \/><\/a><\/p>\n<p>Este caso puede ser comun en procesos de aplicacion con actualizaciones en paralelo sobre la misma tabla.<\/p>\n<p>La manera de la resoluci\u00f3n del mismo puede pasar por ampliar los freelists.<\/p>\n<p>Mas informacion como siempre en soporte oracle <\/p>\n<ul>\n<li>WAITEVENT: \u00abenq: HW &#8211; contention\u00bb Reference Note (Doc ID 2098543.1)\n<li>Analyzing &#8216;enq: HW &#8211; contention&#8217; Wait Event (Doc ID 740075.1)\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Hoy vamos a ver un tipo de evento relaccionado habitualmente con las inserciones. El HW High Water enqueue enq: HW se da cuando varios procesos compiten para aumentar el high water mark de una tabla . Si disponemos del Enterprise &hellip; <a href=\"http:\/\/clemente.pamplona.name\/dba\/evento-de-espera-enq-hw\/\">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,60,3],"tags":[778,26],"class_list":["post-1672","post","type-post","status-publish","format-standard","hentry","category-11g","category-12c","category-tunning","tag-enq-hw","tag-wait"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1672","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=1672"}],"version-history":[{"count":5,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1672\/revisions"}],"predecessor-version":[{"id":1715,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1672\/revisions\/1715"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=1672"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=1672"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=1672"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}