AUTO_SPACE_ADVISOR_JOB takes a lot time
Is this a way to reduce the procedure running time?
Elapsed Elap per CPU Old
Time (s) Executions Exec (s) %Total Time (s) Physical Reads Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
1627.02 116 14.03 6.8 57.63 1,199,341 3778941046
Module: DBMS_SCHEDULER
insert into wri$_adv_objspace_trend_data select timepoint, spac
e_usage, space_alloc, quality from table(dbms_space.object_grow
th_trend(:1, :2, , :4, NULL, NULL, NULL, 'FALSE', :5, 'FALSE'
))
Thanks
Tracy