[oraraj]

Hi,

We have a unix script which calls a package and that in turns loads 2 materialzed views. For the past 2 months the job is exceeding the normal loading time…It was running for 3 to 4 hrs initially and now it is running for 9 to 10 hrs. I am a developer and I want to know what are the measures that I can do from my end in order to first find out what is the reason why it is taking long time. The log does not say anything since this is a package.

Thanks

[Saurabh Sood]

Hi,

What type of Mview are you using? Do you see any waitevent when this package is running?

Thanks.

[Author]

Posts