1 Reply Latest reply on Dec 2, 2008 6:50 AM by KristianW

    Missing stats rollup jobs

    KristianW Novice

       

      Hi all,

       

       

      Today I took some time out of our normally busy schedule, to have a small run over on our VC database. We went through most of the tables in the database.

       

       

      We soon found that the VPX_HIST_STAT1 table was HUGE. Quick google gave us a pinpointer of failing rollup jobs:

       

       

      -Past Day stats rollup

      -Past Week stats rollup

      -Past Month stats rollup

       

       

      Much to my surprise, there was NO jobs set up on the database. Anyone experienced this before, and has a fix?

       

       

      VC2.5.

       

       

      Oracle 10.2.0.4

       

       

       

       

       

      Regards,

       

       

      Kristian