Results 1 to 4 of 4

Thread: SQL Performance

  1. #1
    Join Date
    Aug 2003
    Posts
    9

    Post Unanswered: SQL Performance

    Hi All,
    I am working on a SQR.(consists of differet SQL cursors)
    It is having around 60 procedures(each proc select data from same 4 tables). It is getting hanged in middile of one procedure.
    this program usesed to work well 8 months ago. but now it is hanging.
    I am on Oracle 8i.

    When i run that particular procedure separately its working.
    How can I improve the performance..


    Thanks in Advance......

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    recomplile all the procs and check if any are invalid after you do that.

    It is possible a table-change occurred at some point. Without more information it is tough to determine what is going on.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Aug 2003
    Posts
    9
    Originally posted by The_Duck
    recomplile all the procs and check if any are invalid after you do that.

    It is possible a table-change occurred at some point. Without more information it is tough to determine what is going on.

    Procedures are correct, What do u mean by table-change?
    Is it locking?

    My sql is having only selects..Is there any way i can go ahead onthis...

  4. #4
    Join Date
    Aug 2003
    Posts
    9
    Originally posted by The_Duck
    recomplile all the procs and check if any are invalid after you do that.

    It is possible a table-change occurred at some point. Without more information it is tough to determine what is going on.
    Is there any table locking ??
    Is so how to handle??

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •