-
query running slow..
Hi Gurus,
query is running fast in pre-production(20 sec) but takes 22 min in production , data is almost same in both env.What are the things to be i should looked into?Please any repps would be very helpful.
oracle 10202,hpux-11.2
Regards
-
Both systems have
same config?
same init ?
stats ?
idling ?
run trace and compare.
-
check the explain plan of both query then comapre to each other . You will find the clue that in production database there is some problem of index . second you have to gather the statistics .
-
And compare the workloads. A process run in isolation in Pre-Prod might have to wait for locked resources in a Live environment. Is it just a query? As stated above, EXPLAIN the query in both environments would be the first step. Compare the stats generated.
-
maybe is I/O problem have you the same filesystem in both enviroments.
XFS in both???
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|