Responsibility cover of database expanse growth in creation environments is a must-to-do job of every DBA. Maintaining and news info of past database maturation is always a strain that involves best amount of intellection and programming various jobs in the database. Vaticinator provides time-series segment statistics for tables and indicator in the 10g Automatic workload Sepulchre tables (AWR). These can speedily passage collection for Vaticinator ontogenesis reports. In Diviner 10g, number database development reports are is undemanding because the dba_hist_seg_stat tables provides the delta measure for every array and indicator. Starting from 10g, Diviner has provided us with a flick to accomplish this without untold overhead. Most importantly, we can use this with out incurring any histrion authorisation value. This technique is used by many DBA\'s but not untold substantiation is procurable over the internet for simplified use. This book is laboursaving in pursuit the oracle growing . Superior b.tsname tablespace_name , MAX(b.used_size_mb) cur_used_size_mb , stave(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 ( Divider BY a.tsname Rule BY a.tsname,a.days) inc_used_size_mb FROM ( Superior TO_CHAR(sp.begin_interval_time,\'MM-DD-YYYY\') life ,ts.tsname ,MAX(cumuliform((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 Meet BY TO_CHAR(sp.begin_interval_time,\'MM-DD-YYYY\'), ts.tsname Visit BY ts.tsname, life ) a ) b Set BY b.tsname Rule BY b.tsname;
Friday, October 14, 2011
How To Tracking Oracle database growth
Responsibility cover of database expanse growth in creation environments is a must-to-do job of every DBA. Maintaining and news info of past database maturation is always a strain that involves best amount of intellection and programming various jobs in the database. Vaticinator provides time-series segment statistics for tables and indicator in the 10g Automatic workload Sepulchre tables (AWR). These can speedily passage collection for Vaticinator ontogenesis reports. In Diviner 10g, number database development reports are is undemanding because the dba_hist_seg_stat tables provides the delta measure for every array and indicator. Starting from 10g, Diviner has provided us with a flick to accomplish this without untold overhead. Most importantly, we can use this with out incurring any histrion authorisation value. This technique is used by many DBA\'s but not untold substantiation is procurable over the internet for simplified use. This book is laboursaving in pursuit the oracle growing . Superior b.tsname tablespace_name , MAX(b.used_size_mb) cur_used_size_mb , stave(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 ( Divider BY a.tsname Rule BY a.tsname,a.days) inc_used_size_mb FROM ( Superior TO_CHAR(sp.begin_interval_time,\'MM-DD-YYYY\') life ,ts.tsname ,MAX(cumuliform((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 Meet BY TO_CHAR(sp.begin_interval_time,\'MM-DD-YYYY\'), ts.tsname Visit BY ts.tsname, life ) a ) b Set BY b.tsname Rule BY b.tsname;
