{"id":174,"date":"2021-09-04T19:34:20","date_gmt":"2021-09-05T01:34:20","guid":{"rendered":"https:\/\/folken-it.com\/?p=174"},"modified":"2021-09-04T19:34:21","modified_gmt":"2021-09-05T01:34:21","slug":"mejorar-el-desempeno-de-sqldeveloper-ajustando-el-heapsize","status":"publish","type":"post","link":"https:\/\/folken-it.com\/?p=174","title":{"rendered":"Mejorar el desempe\u00f1o de SQLDeveloper ajustando el heapsize"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Al ser una aplicaci\u00f3n basada en java, podemos ajustar el tama\u00f1o de la memoria que se asigna al iniciar esta aplicaci\u00f3n  por ejemplo, actualmente se esta consumiendo  alrededor de un 1GB.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"774\" height=\"220\" src=\"https:\/\/i0.wp.com\/folken-it.com\/wp-content\/uploads\/2021\/09\/image-6.png?resize=774%2C220&#038;ssl=1\" alt=\"\" class=\"wp-image-175\" srcset=\"https:\/\/i0.wp.com\/folken-it.com\/wp-content\/uploads\/2021\/09\/image-6.png?w=774&amp;ssl=1 774w, https:\/\/i0.wp.com\/folken-it.com\/wp-content\/uploads\/2021\/09\/image-6.png?resize=300%2C85&amp;ssl=1 300w, https:\/\/i0.wp.com\/folken-it.com\/wp-content\/uploads\/2021\/09\/image-6.png?resize=768%2C218&amp;ssl=1 768w\" sizes=\"auto, (max-width: 774px) 100vw, 774px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Por lo que procederemos a asignarle m\u00e1s recursos de memoria para no presentar lentitud.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">En el directorio de instalaci\u00f3n de SQLDeveloper ubicaremos el archivo llamado sqldeveloper.conf , procedemos a abrirlo y en la parte final agregaremos las siguientes l\u00edneas:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>AddVMOption -Xms2048m\nAddVMOption -Xmx2048m<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Guardamos los cambios y reiniciamos SQLDeveloper y ahora  que se establecieron estos valores se reservaran 2GB para esta aplicaci\u00f3n exclusivamente con lo que podemos trabajar sin problemas, dependiendo de los objetos que manipulen incluso pueden incrementar esta valor en m\u00faltiplos de 512m.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Despu\u00e9s de reiniciar veremos que el proceso de sqldeveloper ahora tiene un poco m\u00e1s de memoria asignada y con ello la mejora en el performance.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"717\" height=\"244\" src=\"https:\/\/i0.wp.com\/folken-it.com\/wp-content\/uploads\/2021\/09\/image-7.png?resize=717%2C244&#038;ssl=1\" alt=\"\" class=\"wp-image-176\" srcset=\"https:\/\/i0.wp.com\/folken-it.com\/wp-content\/uploads\/2021\/09\/image-7.png?w=717&amp;ssl=1 717w, https:\/\/i0.wp.com\/folken-it.com\/wp-content\/uploads\/2021\/09\/image-7.png?resize=300%2C102&amp;ssl=1 300w\" sizes=\"auto, (max-width: 717px) 100vw, 717px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Al ser una aplicaci\u00f3n basada en java, podemos ajustar el tama\u00f1o de la memoria que se asigna al iniciar esta aplicaci\u00f3n por [&hellip;]<\/p>\n","protected":false},"author":62,"featured_media":175,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[14],"tags":[],"class_list":["post-174","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sqldeveloper"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/folken-it.com\/wp-content\/uploads\/2021\/09\/image-6.png?fit=774%2C220&ssl=1","_links":{"self":[{"href":"https:\/\/folken-it.com\/index.php?rest_route=\/wp\/v2\/posts\/174","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/folken-it.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/folken-it.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/folken-it.com\/index.php?rest_route=\/wp\/v2\/users\/62"}],"replies":[{"embeddable":true,"href":"https:\/\/folken-it.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=174"}],"version-history":[{"count":1,"href":"https:\/\/folken-it.com\/index.php?rest_route=\/wp\/v2\/posts\/174\/revisions"}],"predecessor-version":[{"id":177,"href":"https:\/\/folken-it.com\/index.php?rest_route=\/wp\/v2\/posts\/174\/revisions\/177"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/folken-it.com\/index.php?rest_route=\/wp\/v2\/media\/175"}],"wp:attachment":[{"href":"https:\/\/folken-it.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=174"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folken-it.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=174"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folken-it.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}