DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Slow performance for Procedure

  1. #1
    Join Date
    Apr 2002
    Posts
    73

    Slow performance for Procedure

    We have a slow procedure, have any suggestions/tools to tune the procedure instead of running the explain plan for every queries in the procedure?

    Thanks

    Blu

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    how about modifying it to log how long each query takes to run, then tackling the longest running query first, etc
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Apr 2002
    Posts
    73
    How can I capture the timing for each query in Procedure, am I able to set timing on ?

  4. #4
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    1) have a DBMS_OUTPUT with SYSDATE before and after the query.

    2) If u can't see the OUTPUT. Have a dummy_process_table where you insert the start and end time
    Cheers!
    OraKid.

  5. #5
    Join Date
    Apr 2002
    Posts
    73
    Thank you so much.

    Blu

Posting Permissions

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


Click Here to Expand Forum to Full Width