{"id":5595,"date":"2023-06-24T08:13:03","date_gmt":"2023-06-24T06:13:03","guid":{"rendered":"http:\/\/rootfan.com\/?p=5595"},"modified":"2023-09-17T11:36:53","modified_gmt":"2023-09-17T09:36:53","slug":"comprobar-el-tamano-de-la-base-de-datos-en-oracle","status":"publish","type":"post","link":"https:\/\/rootfan.com\/es\/check-database-size-in-oracle\/","title":{"rendered":"C\u00f3mo Comprobar el Tama\u00f1o de la Base de Datos en Oracle 19c"},"content":{"rendered":"<p>A menudo necesitas saber el tama\u00f1o de una base de datos Oracle para moverla de un servidor a otro. O simplemente para saber si su exportaci\u00f3n o lo que sea va a ocupar mucho espacio y tiempo.<\/p>\n\n\n\n<p>En este art\u00edculo le muestro una forma sencilla de calcular el tama\u00f1o de su base de datos Oracle.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Tama\u00f1o de los archivos de datos Oracle en GB<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect sum(bytes)\/(1024*1024*1024) G \nfrom dba_data_files;\n<\/pre><\/div>\n\n\n<!--more-->\n\n\n\n<h2 class=\"wp-block-heading\">Tama\u00f1o de los archivos temporales de Oracle en GB<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect sum(bytes)\/(1024*1024*1024) G \nfrom dba_temp_files;\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">Tama\u00f1o de los redo logs de Oracle en GB<\/h2>\n\n\n\n<p>No tiene en cuenta los archivos redolog reflejados:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect sum(bytes)\/(1024*1024*1024) G \nfrom v$log;\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">Tama\u00f1o del espacio utilizado de los archivos de datos de Oracle<\/h2>\n\n\n\n<p>Esto le dar\u00e1 el espacio total utilizado dentro de la base de datos en GB.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect sum(bytes)\/(1024*1024*1024) G \nfrom dba_segments;\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">Tama\u00f1o total de la base de datos Oracle<\/h2>\n\n\n\n<p>Tambi\u00e9n se tienen en cuenta los archivos de control y los archivos redolog reflejados.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect a.data_size+b.temp_size+c.redo_size+d.cont_size &quot;total_size&quot;\nfrom ( select sum(bytes) data_size\nfrom dba_data_files ) a,\n( select nvl(sum(bytes),0) temp_size\nfrom dba_temp_files ) b,\n( select sum(bytes) redo_size\nfrom sys.v_$logfile lf, sys.v_$log l\nwhere lf.group# = l.group#) c,\n( select sum(block_size*file_size_blks) cont_size\nfrom v$controlfile ) d;\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>A menudo necesitas saber el tama\u00f1o de una base de datos Oracle para moverla de un servidor a otro. O simplemente para saber si su exportaci\u00f3n o lo que sea va a ocupar mucho espacio y tiempo. En este art\u00edculo te muestro una forma sencilla de calcular el tama\u00f1o de tu base de datos Oracle. ... <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/rootfan.com\/es\/check-database-size-in-oracle\/\" class=\"more-link\">Seguir leyendo<span class=\"screen-reader-text\"> \"C\u00f3mo comprobar el tama\u00f1o de la base de datos en Oracle 19c\"<\/span><\/a><\/p>","protected":false},"author":1,"featured_media":5608,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_focus_keyword":"check database size oracle","rank_math_title":"","rank_math_description":"Find out how to check the size of your Oracle 19c database. Stay informed about your data storage effortlessly!","rank_math_robots":"","rank_math_og_title":"","rank_math_og_description":"","jetpack_post_was_ever_published":false,"_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":""},"categories":[31],"tags":[97],"class_list":["post-5595","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-size"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/rootfan.com\/wp-content\/uploads\/pexels-photo-1423600.jpeg?fit=1880%2C1253&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/5595","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/comments?post=5595"}],"version-history":[{"count":9,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/5595\/revisions"}],"predecessor-version":[{"id":5623,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/5595\/revisions\/5623"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media\/5608"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media?parent=5595"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/categories?post=5595"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/tags?post=5595"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}