Showing object growth over a month from AWR

Another useful piece of code that accesses data from the AWR

select *
  from table(dbms_space.object_growth_trend('CURVE_DATA_STORE',
                                            'BINARY_BUCKET',
                                            'TABLE'));

Will show the growth of that object over the past month (or however much data is retained in your AWR)

0 comments:

Post a Comment