{"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":"verifier-la-taille-de-la-base-de-donnees-dans-oracle","status":"publish","type":"post","link":"https:\/\/rootfan.com\/fr\/check-database-size-in-oracle\/","title":{"rendered":"Comment v\u00e9rifier la taille de la base de donn\u00e9es dans Oracle 19c"},"content":{"rendered":"<p>Vous avez souvent besoin de conna\u00eetre la taille d'une base de donn\u00e9es Oracle pour la d\u00e9placer d'un serveur \u00e0 un autre. Ou simplement pour savoir si votre exportation ou autre va prendre beaucoup d'espace et de temps.<\/p>\n\n\n\n<p>Dans cet article, je vous montre une m\u00e9thode simple pour calculer la taille de votre base de donn\u00e9es Oracle.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Taille des fichiers de donn\u00e9es Oracle en Go<\/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\">Taille des fichiers tempfiles Oracle en Go<\/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\">Taille des redo logs Oracle en Go<\/h2>\n\n\n\n<p>Ne prend pas en compte les fichiers redolog en miroir :<\/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\">Taille de l'espace occup\u00e9 par vos fichiers de donn\u00e9es Oracle<\/h2>\n\n\n\n<p>Vous obtiendrez ainsi l'espace total utilis\u00e9 dans la base de donn\u00e9es en Go.<\/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\">Taille totale de la base de donn\u00e9es Oracle<\/h2>\n\n\n\n<p>Il faut \u00e9galement tenir compte des fichiers de contr\u00f4le et des fichiers redolog en miroir.<\/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>Vous avez souvent besoin de conna\u00eetre la taille d'une base de donn\u00e9es Oracle pour la d\u00e9placer d'un serveur \u00e0 un autre. Ou simplement pour savoir si votre exportation ou autre va prendre beaucoup d'espace et de temps. Dans cet article, je vous montre une m\u00e9thode simple pour calculer la taille de votre base de donn\u00e9es Oracle. ... <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/rootfan.com\/fr\/check-database-size-in-oracle\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de \" Comment v\u00e9rifier la taille de la base de donn\u00e9es dans 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\/fr\/wp-json\/wp\/v2\/posts\/5595","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/comments?post=5595"}],"version-history":[{"count":9,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/5595\/revisions"}],"predecessor-version":[{"id":5623,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/5595\/revisions\/5623"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media\/5608"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media?parent=5595"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/categories?post=5595"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/tags?post=5595"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}