Does anyone know the best way to monitor table growth in oracle during a job. For example when migrating code from a development to a production environment it would be useful to snapshot vital oracle dba statistics during the course of a job to decide if our production database environment needs to be scaled up and by how much.
All suggestions are welcome. Thanks in advance.
sajohal (BOB member since 2008-04-29)
select sum(bytes) from user_extents where segment_name = ‘my_table_name’
??
Werner Daehn 
(BOB member since 2004-12-17)
Thanks Werner I also came across another Oracle 10G table called, dba_hist_seg_stat which holds historical information but I was after a smarter way to monitor table growth during the course of a DI job and snapshot the data into a table where I could see the spikes and decide if I need to grow my production environment.
To be honest this is probably for an oracle forum, on which note i did find this link.
sajohal (BOB member since 2008-04-29)