package running slowly

  • This topic is empty.
Viewing 1 reply thread
  • 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.

Viewing 1 reply thread
  • You must be logged in to reply to this topic.