dbms_space.object_growth_trend

Q. What does the following query do? It is one of the most expensive Queries.


insert into wri$_adv_objspace_trend_data select timepoint,
 space_usage, space_alloc, quality from
      table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL,
         NULL, 'FALSE', :5, 'FALSE'))

A:
It is used to collect data for space adviser for enterprise manager. You can disable the job if you don't use space adviser.
Execute dbms_scheduler.disable('sys.auto_space_advisor_job');

The real problem is solved if we go to 10.2.0.4.
And yes it has to do with bug 5376783.
All users on 10.2.0.2 have this performance problem !!!
https://forums.oracle.com/forums/thread.jspa?threadID=1111378