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

Thread: 10.2.04 - Different explain plan

  1. 12-14-2009, 04:01 AM #1
    newbie
    newbie is offline Member
    Join Date
    Mar 2001
    Posts
    149

    10.2.04 - Different explain plan

    Hi all,

    I have 2 10gR2 databases running on two identical servers (both db have same set of init parameters) but when I run a long running query on both of them, each of the server has different explain plan? I'm not sure what's causing this? Both have stats regenerated. Please advise. Thanks
    Reply With Quote Reply With Quote
  2. 12-14-2009, 05:12 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    becuase everything isnt the same - you need to worj out what is different (start with the stats)
    Reply With Quote Reply With Quote
  3. 12-17-2009, 02:30 PM #3
    Thomas7
    Thomas7 is offline Junior Member
    Join Date
    May 2009
    Posts
    32
    Export the stats from one DB SERVER and import them to other DB on otner server, so that you can have a good chance of having same explain plans.
    Reply With Quote Reply With Quote
  4. 12-18-2009, 01:13 AM #4
    giteshtrivedi
    giteshtrivedi is offline Junior Member
    Join Date
    Mar 2001
    Location
    India
    Posts
    57
    Are those tables contain also same data?
    Thanks and Regards,
    Gitesh Trivedi
    Dbametrix Solutions
    Database DBA support
    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