VMware Cloud Community
KristianW
Contributor
Contributor

Missing stats rollup jobs

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

0 Kudos
1 Reply
KristianW
Contributor
Contributor

haha, as always when I post a question on a forum - 5 minutes later I find the answer.

This one answers my questions:

http://communities.vmware.com/thread/123715

Been searching for quite some time now.

-Kristian

0 Kudos