{"id":2107,"date":"2019-08-25T10:53:55","date_gmt":"2019-08-25T08:53:55","guid":{"rendered":"http:\/\/clemente.pamplona.name\/dba\/?p=2107"},"modified":"2020-07-20T16:28:48","modified_gmt":"2020-07-20T14:28:48","slug":"errores-heap-size-xx-exceeds-notification-threshold","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/errores-heap-size-xx-exceeds-notification-threshold\/","title":{"rendered":"Errores Heap size XX exceeds notification threshold"},"content":{"rendered":"

Hoy vamos a volver con las entradas para dummies<\/p>\n

Uno de las alertas con las que podemos encontrarnos en el fichero de log es :<\/p>\n

\r\n2019-08-25T21:51:19.646997+01:00\r\nPDB$SEED(2):Memory Notification: Library Cache Object loaded into SGA\r\nHeap size 52942K exceeds notification threshold (51200K)\r\nDetails in trace file \/u01\/app\/oracle\/diag\/rdbms\/test\/TEST\/trace\/TEST_ora_32087.trc\r\n2019-08-25T21:51:19.647135+01:00\r\nPDB$SEED(2):KGL object name :grant read on ku$_m_view_piot_view to public\r\n2019-08-25T21:51:33.513723+01:00\r\nPDB$SEED(2):Memory Notification: Library Cache Object loaded into SGA\r\nHeap size 52903K exceeds notification threshold (51200K)\r\nDetails in trace file \/u01\/app\/oracle\/diag\/rdbms\/test\/TEST\/trace\/TEST_ora_32087.trc\r\n2019-08-25T21:51:33.513818+01:00\r\nPDB$SEED(2):KGL object name :grant read on ku$_zm_view_piot_view to public\r\n<\/pre>\n
A pesar del susto que nos puede dar esta alerta , no se trata de un error, sino de un warning. A partir de la version 10g oracle introdujo un umbral a partir del cual nos avisa cuando superamos ese  umbral en la carga de objetos en el shared pool .
\nEste umbral viene definido por el parametro oculto _kgl_large_heap_warning_threshold<\/b><\/p>\n
Si queremos saber el valor actual de este valor podemos ejecutar la consulta <\/p>\n
[code lang=\u00bbsql\u00bb]
\nselect
\nnam.ksppinm NAME,
\nnam.ksppdesc DESCRIPTION,
\nval.KSPPSTVL
\nfrom
\nx$ksppi nam,
\nx$ksppsv val
\nwhere nam.indx = val.indx and nam.ksppinm like ‘%kgl_large_heap_%_threshold%’;
\n[\/code]<\/p>\n
En caso de que quieresemos que dejasen de apareer alertas (especialmente por que vienen asociadas a una traza ) podemos modificar el parametro con :<\/p>\n
\r\n alter system set \"_kgl_large_heap_warning_threshold\"=XXXXXX   comment='motivo aqui ' scope=spfile;\r\n<\/pre>\n
Como podeis ver, hemos de acutalizar en el spfile por lo que habra que reiniciar la base de datos si quremos que haga efecto <\/p>\n
Como siempre podemos tener mas informacion en la nota de soporte KGL-heap-size-exceeded] (Doc ID 330239.1)<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Hoy vamos a volver con las entradas para dummies Uno de las alertas con las que podemos encontrarnos en el fichero de log es : 2019-08-25T21:51:19.646997+01:00 PDB$SEED(2):Memory Notification: Library Cache Object loaded into SGA Heap size 52942K exceeds notification threshold … Sigue leyendo →<\/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":[565,567,921,975,9,66,569],"tags":[985,984,983,986],"class_list":["post-2107","post","type-post","status-publish","format-standard","hentry","category-11g-en","category-12c-en","category-18c","category-19c","category-dummie","category-errores-ora","category-ora-errors","tag-exceeds-notification-threshold","tag-exceeds","tag-heap","tag-kgl-heap-size-exceeded"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2107","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=2107"}],"version-history":[{"count":3,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2107\/revisions"}],"predecessor-version":[{"id":2111,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2107\/revisions\/2111"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=2107"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=2107"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=2107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}