{"id":77,"date":"2023-02-13T18:35:31","date_gmt":"2023-02-13T16:35:31","guid":{"rendered":"http:\/\/130.61.57.200\/?p=77"},"modified":"2023-04-12T11:16:39","modified_gmt":"2023-04-12T09:16:39","slug":"how-to-see-table-growth-in-oracle","status":"publish","type":"post","link":"http:\/\/130.61.57.200\/index.php\/2023\/02\/13\/how-to-see-table-growth-in-oracle\/","title":{"rendered":"How to see table growth in Oracle"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>SELECT obj.owner, obj.object_name,\n           to_char(sn.BEGIN_INTERVAL_TIME,&#039;DD-MON-RR&#039;) start_day,\n           ROUND(sum(a.db_block_changes_delta)\/***8\/1024\/1024,2***\/) gb_increase\n  from     dba_hist_seg_stat a,\n           dba_hist_snapshot sn,\n           dba_objects obj\n  where    sn.snap_id = a.snap_id\n  and      obj.object_id = a.obj#\n  and      obj.owner not in (&#039;SYS&#039;,&#039;SYSTEM&#039;)\n  and        obj.object_name=&#039;&amp;TABLE&#039;\n  and      end_interval_time between to_timestamp(&#039;4-FEB-23&#039;,&#039;DD-MON-RR&#039;)\n           and to_timestamp(&#039;13-FEB-23&#039;,&#039;DD-MON-RR&#039;)\n  group by obj.owner, obj.object_name,\n           to_char(sn.BEGIN_INTERVAL_TIME,&#039;DD-MON-RR&#039;)\n  order by obj.owner, obj.object_name<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":106,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[29,38],"class_list":["post-77","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-size","tag-table"],"blocksy_meta":[],"_links":{"self":[{"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/posts\/77","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/comments?post=77"}],"version-history":[{"count":1,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/posts\/77\/revisions"}],"predecessor-version":[{"id":78,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/posts\/77\/revisions\/78"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/media\/106"}],"wp:attachment":[{"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/media?parent=77"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/categories?post=77"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/tags?post=77"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}