Query performance
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Query performance

  1. #1
    Join Date
    Oct 2001
    Posts
    52

    Question Query performance

    Hi all,
    Our customer had encountered some performance issue when running a particular procedure after they refresh the database instance. They duplicate the instance using the disk to disk copy via fiber on different Compact Tru64 machine. It should be exactly the same for both of the database. (all database objects and data was identical)

    It took about 30 sec to run the procedure in the production instance. However, when they run the same procedure in the new instance we face the performance issue. It take >30 minutes to finish and sometime it would continue running >1hrs and never finish.

    However, we can get rid of these if we created a new view on the particular table inside the procedure. And we need to explain to them why this happen.

    Question:-
    1. What could be the possible problem in this case? Please explain your answer.

    Please advice.

    Thanks in advance.

    Rgds,
    GS

  2. #2
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    Same hardware and initialization parameter file?
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Have you checked for differences in the execution plan for the queries, or attempted to find the queries that are causing the delay?
    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE

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