Re: OBJECT_GROWTH_TREND function

Posted by ErmanArslansOracleBlog on Oct 09, 2018; 10:10am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/OBJECT-GROWTH-TREND-function-tp6829p6830.html

It is already documented Roshan.
It uses AWR data to report object growth trends.

Here are some examples of the usage:

SELECT *
FROM   TABLE(DBMS_SPACE.object_growth_trend ('SCOTT','EMP','TABLE'))
ORDER BY timepoint;

SELECT TIMEPOINT, SPACE_USAGE, SPACE_ALLOC, QUALITY FROM TABLE (DBMS_
SPACE.OBJECT_GROWTH_TREND ('DEV_SOAINFRA','COMPOSITE_INSTANCE','TABLE'));

In the output, you should concantrate on timepoint and space* columns. So that, you can make a decision about the growth trends of your objects.