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'))

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
And yes it has to do with bug 5376783.
All users on have this performance problem !!!


No comments:

Post a Comment