Stats job is running for ages.

[Former Member]

Hi,

One of the Stats job for Cube is running for long time. It used to come in before 40 min. Now a days it is running for long time. Then everday i am killing the job and running stats job at oracle level. Could you please tell me how to fix this issue to come back my stats job to original position.

Thanks

Neeraj

Message was edited by:

Neeraj B

[former_member184494]

Neeraj,

Welcome to SDN....

what does the job log say ?

what are the data volumes on the cube

what percentage of fact is being used for stats ?

Arun

[Former Member]

Job log is saying still running.

volume is 10 lakhs records,

percentage for stat 10