{"id":866,"date":"2014-01-31T12:30:47","date_gmt":"2014-01-31T11:30:47","guid":{"rendered":"http:\/\/clemente.pamplona.name\/dba\/?p=866"},"modified":"2014-01-31T12:48:09","modified_gmt":"2014-01-31T11:48:09","slug":"escribir-en-el-alert-log","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/escribir-en-el-alert-log\/","title":{"rendered":"Escribir en el alert.log"},"content":{"rendered":"<p>Hoy vamos a volver a ver otra funcion de dummies.<\/p>\n<p>\u00bfPodemos escribir en el alert.log?<\/p>\n<p>La respuesta es que si , para ello tenemos la funcion <em><b>DBMS_System.ksdwrt<\/b><\/em>, que sirve para escribir tanto en el alert como en un fichero de traza.<\/p>\n<p>La funci\u00f3n es  EXEC DBMS_System.ksdwrt(n, message); donde tenemos que  n es:<br \/>\n1 &#8211; Write to trace file.<br \/>\n2 &#8211; Write to alertlog.<br \/>\n3 &#8211; Write to both.<\/p>\n<p>As\u00ed pues, si queremos escribir un mensaje en el alert.log deberemos de poner <\/p>\n<pre>\r\n\r\nexec dbms_system.ksdwrt(2, 'Esto lo escribimos en el  alert log');\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Hoy vamos a volver a ver otra funcion de dummies. \u00bfPodemos escribir en el alert.log? La respuesta es que si , para ello tenemos la funcion DBMS_System.ksdwrt, que sirve para escribir tanto en el alert como en un fichero de &hellip; <a href=\"http:\/\/clemente.pamplona.name\/dba\/escribir-en-el-alert-log\/\">Sigue leyendo <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,7],"tags":[140,141,142],"class_list":["post-866","post","type-post","status-publish","format-standard","hentry","category-dummie","category-sqlplus","tag-alert","tag-ksdwrt","tag-sys-dbms_system-ksdwrt"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/866","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=866"}],"version-history":[{"count":3,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/866\/revisions"}],"predecessor-version":[{"id":869,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/866\/revisions\/869"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=866"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=866"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=866"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}