Re: SQL to generate percentage growth per time period?

DG problem wrote:
> Just wondering what is the easiest way to show percentage growth of
> database objects per time period.
>
> For example, what SQL would show the weekly percentage growth of the
> following data?
>
> alter session set nls_date_format= 'YYYYmmdd';
> create table t (time date,mb integer);
> insert into t values('20071117',103442);
> insert into t values('20071110',97592);
> insert into t values('20071103',93446);
> insert into t values('20071026',87648);
> insert into t values('20071020',84191);
> insert into t values('20071013',76495);
> insert into t values('20071006',72294);
> commit ;
> select * from t order by 1 desc ;
>
> Thanks

SELECT timepoint, delta_space_usage, delta_space_alloc, total_space_usage, total_space_alloc
FROM TABLE(dbms_space.object_growth_trend_swrf(USER, 'T', 'TABLE'));

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org