Database Tuning (MOSC)

MOSC Banner

AUTO_SPACE_ADVISOR_JOB takes a lot time

edited Jul 11, 2012 5:26AM in Database Tuning (MOSC) 10 commentsAnswered
Hi,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center