This post is more than 5 years old
2 Intern
•
643 Posts
0
2169
March 9th, 2012 19:00
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)?
No Events found!
zhaos2
2 Intern
•
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?
zhaos2
2 Intern
•
643 Posts
0
May 24th, 2012 19:00
Very much appreciated!
Can you also explain on dba_extents?
zhaos2
2 Intern
•
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.