|
-
 Originally Posted by avion1
The query is (a simple select ) taking very long time.
Timing:
real 2m20.192s
user 1m52.123s
sys 0m22.978s
Could someone, please advise where else to look at.
Provided information is out of context and really means nothing.
Have you compared execution plans? old server vs. new server?
Does the technology refresh includes new storage subsystem?
Have you compared wait events? old server vs. new server?
Are database setup identical? old server vs. new server?
Have you moved to an upper version of Oracle during the technology refresh?
Would you mind in describing "how" you moved the database to the new server?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
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
|
Reply With Quote