top of page
Segment Growth

SELECT to_char(timepoint,'DD-MON-YYYY HH24:MI'),space_usage,space_alloc,quality
FROM
  table(
   DBMS_SPACE.OBJECT_GROWTH_TREND (
    object_owner => 'SYSTEM',
    object_name  => 'REPCAT$_REPSCHEMA',
    object_type  => 'TABLE',
    partition_name => '',
    start_time =>SYSDATE-360,
   end_time   =>SYSDATE+360,
   interval   =>to_dsinterval( '0 12:00:00')  ,
   skip_interpolated => 'FALSE',
   timeout_seconds =>NULL,
   single_datapoint_flag =>'TRUE')
 )

Download Speedway to graphically plot the above script results.

Complete Database Performance Management
bottom of page