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.
1. What could be the possible problem in this case? Please explain your answer.
Thanks in advance.
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
Have you checked for differences in the execution plan for the queries, or attempted to find the queries that are causing the delay?
Click Here to Expand Forum to Full Width