Here you can find two scripts those are database growth per month and tablespace level database growth.
The below script lists the details of database growth per month:
select to_char(creation_time, 'MM-RRRR') "Month", sum(bytes)/1024/1024/1024 "Growth in GB"
from sys.v_$datafile
where to_char(creation_time,'RRRR')='2014'
group by to_char(creation_time, 'MM-RRRR')
order by to_char(creation_time, 'MM-RRRR');
Sample output from the script:
Month Growth in GB
------------------------------------------------------------ -----------------
05-2014 101.588867
06-2014 525.609375
07-2014 57.5
09-2014 10
10-2014 31.0976563
11-2014 52
Below script is useful for tablespace level database growth:
The below script lists the details of database growth per month:
select to_char(creation_time, 'MM-RRRR') "Month", sum(bytes)/1024/1024/1024 "Growth in GB"
from sys.v_$datafile
where to_char(creation_time,'RRRR')='2014'
group by to_char(creation_time, 'MM-RRRR')
order by to_char(creation_time, 'MM-RRRR');
Sample output from the script:
Month Growth in GB
------------------------------------------------------------ -----------------
05-2014 101.588867
06-2014 525.609375
07-2014 57.5
09-2014 10
10-2014 31.0976563
11-2014 52
Below script is useful for tablespace level database growth:
select b.tsname tablespace_name , MAX(b.used_size_mb) cur_used_size_mb , round(AVG(inc_used_size_mb),2)avg_increas_mb
from ( SELECT a.days,a.tsname , used_size_mb , used_size_mb - LAG (used_size_mb,1) OVER ( PARTITION BY a.tsname ORDER BY a.tsname,a.days) inc_used_size_mb
from ( SELECT TO_CHAR(sp.begin_interval_time,'MM-DD-YYYY') days ,ts.tsname ,MAX(round((tsu.tablespace_usedsize* dt.block_size )/(1024*1024),2)) used_size_mb
from dba_hist_tbspc_space_usage tsu , dba_hist_tablespace_stat ts ,dba_hist_snapshot sp, dba_tablespaces dt where tsu.tablespace_id= ts.ts#
AND tsu.snap_id = sp.snap_id
AND ts.tsname = dt.tablespace_name AND sp.begin_interval_time > sysdate-7
GROUP BY TO_CHAR(sp.begin_interval_time,'MM-DD-YYYY'), ts.tsname
ORDER BY ts.tsname, days ) a ) b GROUP BY b.tsname ORDER BY b.tsname;
Sample output from the script:
TABLESPACE_NAME CUR_USED_SIZE_MB AVG_INCREAS_MB
--------------------------------- --------------------------- -------------------------
DW_AGG 8150.31 46.94
DW_DAC_REP_DATA 858.31 3.29
DW_DIM_DATA 7078.81 6
DW_DIM_INDX 3229.69 3.89
DW_DIM_STG 1202.38 -9.61
DW_FACT_DATA 304706.94 894.51
DW_FACT_INDX 32227.81 183.04
DW_FACT_STG 5483.81 120.7
DW_INFA_DOMAIN_DATA 1 0
DW_INFA_REP_DATA 3617.88 2.43
DW_OTHER 14314.88 83.68
DW_OTHER_INDX 203.81 .71
PRD_BIPLATFORM 7493 64.57
PRD_MDS 13.44 0
SYSAUX 7097.75 -3.94
SYSTEM 2408.31 10.43
UNDOTBS1 62488.13 7074.66
UNDOTBS2 13088.38 -866.43
UNDOTBS3 81902 10326
USERS 2015.13 -2.68
Hope this scripts will help you. :)
Best Regards,
Chowdari
Hi Chowdari.
ReplyDeleteThe tablespace growth out put shown your blog is for last one month or year.
Please confirm.
Thanks - Pradeep
Chowdari'S Oracle Dba Blog / Weblog: Script: Oracle Database Growth Per Month >>>>> Download Now
Delete>>>>> Download Full
Chowdari'S Oracle Dba Blog / Weblog: Script: Oracle Database Growth Per Month >>>>> Download LINK
>>>>> Download Now
Chowdari'S Oracle Dba Blog / Weblog: Script: Oracle Database Growth Per Month >>>>> Download Full
>>>>> Download LINK Er
v$datafile re-sets every time you restart the database. SO the query is not for ideal case.
ReplyDeleteThis is growth on database wise. I want to track the growth schema wise per month. I can get current size from user_segments but I Need for previous months as well.
ReplyDeleteChowdari'S Oracle Dba Blog / Weblog: Script: Oracle Database Growth Per Month >>>>> Download Now
ReplyDelete>>>>> Download Full
Chowdari'S Oracle Dba Blog / Weblog: Script: Oracle Database Growth Per Month >>>>> Download LINK
>>>>> Download Now
Chowdari'S Oracle Dba Blog / Weblog: Script: Oracle Database Growth Per Month >>>>> Download Full
>>>>> Download LINK
smm panel
ReplyDeleteSmm Panel
iş ilanları blog
instagram takipçi satın al
HİRDAVATCİBURADA.COM
https://www.beyazesyateknikservisi.com.tr
SERVİS
Tiktok Jeton Hilesi İndir
Good content. You write beautiful things.
ReplyDeletetaksi
mrbahis
vbet
mrbahis
hacklink
korsan taksi
hacklink
sportsbet
sportsbet
manisa
ReplyDeletemaraş
mardin
marmaris
mersin
ZATQSU
kağıthane
ReplyDeletemuğla
tuzla
etiler
maltepe
E46LTW
The consistent Oracle database growth per month is truly impressive. How Guard Business Such steady growth showcases the robustness and reliability of Oracle, making it a reliable choice for handling data-intensive tasks. A commendable feat.
ReplyDeletehttps://saglamproxy.com
ReplyDeletemetin2 proxy
proxy satın al
knight online proxy
mobil proxy satın al
QCD8V
adapazarı
ReplyDeleteadıyaman
afyon
alsancak
antakya
WWN4A4
düzce
ReplyDeletesakarya
tunceli
van
bayburt
DXS6H
ankara parça eşya taşıma
ReplyDeletetakipçi satın al
antalya rent a car
antalya rent a car
ankara parça eşya taşıma
64TLH1
7436B
ReplyDeleteBolu Lojistik
Kocaeli Parça Eşya Taşıma
Kütahya Lojistik
Antep Lojistik
Tunceli Parça Eşya Taşıma
0666C
ReplyDeleteÜnye Evden Eve Nakliyat
Kilis Parça Eşya Taşıma
Ankara Evden Eve Nakliyat
Hakkari Lojistik
Mercatox Güvenilir mi
Çankırı Lojistik
Çerkezköy Asma Tavan
Bayburt Şehir İçi Nakliyat
Yozgat Parça Eşya Taşıma
E48B1
ReplyDeleteKonya Evden Eve Nakliyat
Nevşehir Evden Eve Nakliyat
dianabol methandienone
steroid cycles for sale
Tokat Evden Eve Nakliyat
Tekirdağ Fayans Ustası
Diyarbakır Evden Eve Nakliyat
sarms
buy winstrol stanozolol
E3482
ReplyDeleteBig Wolf Coin Hangi Borsada
Zonguldak Lojistik
Jns Coin Hangi Borsada
Rize Evden Eve Nakliyat
Trabzon Evden Eve Nakliyat
İzmir Şehirler Arası Nakliyat
Ünye Petek Temizleme
Hexa Coin Hangi Borsada
Bitci Güvenilir mi
AB90A
ReplyDeleteurfa görüntülü sohbet canlı
sakarya telefonda canlı sohbet
samsun sohbet odaları
en iyi ücretsiz sohbet siteleri
karabük yabancı görüntülü sohbet uygulamaları
maraş rastgele canlı sohbet
parasız görüntülü sohbet
canlı görüntülü sohbet odaları
mobil sohbet sitesi
9E5FD
ReplyDeletebedava sohbet odaları
Mardin Ücretsiz Sohbet Odaları
Adıyaman Görüntülü Sohbet Kadınlarla
Aksaray En İyi Ücretsiz Sohbet Uygulamaları
kilis görüntülü sohbet
Amasya Parasız Sohbet
Kilis Canli Goruntulu Sohbet Siteleri
istanbul yabancı görüntülü sohbet siteleri
Antep Parasız Görüntülü Sohbet
11D01
ReplyDeleteGörüntülü Sohbet Parasız
Kripto Para Üretme
Soundcloud Takipçi Hilesi
Ön Satış Coin Nasıl Alınır
Facebook Sayfa Beğeni Hilesi
Bitcoin Madenciliği Nasıl Yapılır
Linkedin Beğeni Hilesi
Bitranium Coin Hangi Borsada
Bitcoin Nedir
2F45C
ReplyDeletesolflare
dexscreener
arbitrum
ledger desktop
dcent
galagames
dappradar
poocoin
dextools
8BB3F67988
ReplyDeleteyoutube ucuz beğeni
BE7D0C2BAF
ReplyDeleteinstagram ucuz takipçi
CE228F0E0E
ReplyDeleteTürkiye’de En Çok Oynanan MMORPG Oyunlar
Takipçi Satın Al
Online Hayatta Kalma Oyunları Pc
En Güvenilir Vpn Android iPhone
Kasmalı Oyunlar
En Güvenilir Vpn Hangisi
gercek takipci satin al
Sevgiliyle Oynanacak Pc Oyunları
Oyna Coin Kazan