OBJECT_GROWTH_TREND function

[Roshan]

Hello Erman,

could you please help on the procedure below for OBJECT_GROWTH_TREND?

OBJECT_GROWTH_TREND.txtReference: https://docs.oracle.com/database/121/ARPLS/d_space.htm#ARPLS68097

Thanks,

Roshan

[ErmanArslansOracleBlog]

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.

[Roshan]

select * from table(dbms_space.object_growth_trend

                            (object_owner => 'TESTBI',

                            object_name  => 'MOBILE_DATA',

                            object_type  => 'TABLE PARTITION',

                            partition_name => 'MOBILE_DATA_2018_10',

                            start_time => '09-oct-18 01.00.24.104688000',

                            end_time  => '09-SEP-18 15.20.24.104688000')) order by timepoint;

 

Why is the timepoint displaying

 

08-OCT-18 04.50.41.247545000 39794000595 39862665216 INTERPOLATED

09-OCT-18 01.00.24.104688000 39794000595 39862665216 INTERPOLATED

[ErmanArslansOracleBlog]

Because it is a timestamp. You can convert timestamp to date , if you want to..