Thread: Unusual high query execution time
View Single Post
  #11 (permalink)  
Old 08-26-10, 13:04
LKBrwn_DBA LKBrwn_DBA is offline
Registered User
  
Join Date: Jun 2003
Location: West Palm Beach, FL
Posts: 2,455
Cool Awr?
Quote:
Originally Posted by rahul_pat1748 View Post
... Etc ...
We don't know, on which day will it take long time to run and on that day put the trace on. Its completely unexpected behavior and no pattern applies.
Did you generate AWR report for the day/time this occurs?
__________________
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
Reply With Quote