Login  Register

Re: OBJECT_GROWTH_TREND function

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

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