This post is more than 5 years old
643 Posts
0
2131
Oracle Data Growth for Storage Sizing
Estimated data growth rate is important part of Oracle storage sizing. For an accurate database growth prediction, is there any way from Oracle to calculate how much of data increased in the last a period of time (e.g. per month)?
Anonymous
5 Practitioner
5 Practitioner
•
274.2K Posts
0
May 24th, 2012 19:00
if you want how much space your oracle datafiles occupies then use dba_data_files , or if you want exactly what oracle is using now, please use dba_segments. thanks.
zhaos2
643 Posts
0
March 11th, 2012 23:00
I searched on the internet, there are a few Queries can be used for database sizing information:
dba_data_files:
dba_segments:
dba_extents
Can anyone advice which will be more accurate for data growth calculation? and how should I work out the actaul data growth in a period of time?
Anonymous
5 Practitioner
5 Practitioner
•
274.2K Posts
0
May 24th, 2012 19:00
DBA_EXTENTSdescribes the extents comprising the segments in all tablespaces in the database.zhaos2
643 Posts
0
May 24th, 2012 19:00
Very much appreciated!
Can you also explain on dba_extents?
zhaos2
643 Posts
0
May 24th, 2012 20:00
Thanks! It probably explained why I got different results by using dba_extents and dab_segments.
LouisLu
161 Posts
0
May 24th, 2012 23:00
I believe starting from 10g Oracle has provided us with a feature to measuring Database space growth. This delta information can be queried using views DBA_HIST_SEG_STAT by collecting segment growth periodically. There are a lot SQL code you can search on-line.
One interesting thing I find is that some article said Oracle provides time-series segment statistics for tables and index in the 10g Automated workload Repository tables (AWR). But I really got no space information in my sample AWR report. It has only segment/tablespace IO stats. Maybe many AWR collection method existed I need to research.