10.2.04 - Different explain plan
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: 10.2.04 - Different explain plan

  1. #1
    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    becuase everything isnt the same - you need to worj out what is different (start with the stats)

  3. #3
    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.

  4. #4
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width