package running slowly

Home Forums Database Administration package running slowly

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

  • Author
  • #1951



    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.


  • #2133

    Saurabh Sood


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


You must be logged in to reply to this topic.