DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 34

Thread: SQL query takes 6 hours to execute

Threaded View

  1. 05-03-2010, 10:25 AM #12
    mahajanakhil198
    mahajanakhil198 is offline Senior Member
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    Quote Originally Posted by PAVB View Post
    .out is your session log
    .prf is the one where the fun begins
    Here are the two files attached.
    Could you please guide me on how I could proceed further?

    I was seeing the trace file. Can you please tell what is 'pr', 'pw' and 'us' (which is unit of time, I guess it is microsecond)?
    Attached Files Attached Files
    lucky
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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