DBMS_SPACE.OBJECT_GROWTH_TREND can be used for object size growth trend analysis.For example, for weekly analysis:
SELECT *
FROM
table(
DBMS_SPACE.OBJECT_GROWTH_TREND (
object_owner =>'TABLE_OWNER',
object_name =>'TABLE_NAME',
object_type =>'TABLE PARTITION',
partition_name =>'01',
start_time =>NULL,
end_time =>NULL,
interval =>to_dsinterval('7 00:00:00') ,
skip_interpolated => 'FALSE',
timeout_seconds =>NULL,
single_datapoint_flag =>'TRUE')
)
order by 1
/
No comments:
Post a Comment