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