package running slowly

Home Forums Database Administration package running slowly

This topic contains 1 reply, has 0 voices, and was last updated by  oraraj 5 years, 9 months ago.

  • Author
    Posts
  • #1951

    oraraj
    Participant

    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

  • #2133

    Saurabh Sood
    Member

    Hi,

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

    Thanks.

You must be logged in to reply to this topic.