Re: Performance issue post database analyze, need to understand whats wrong in analyze

  • From: Karl Arao <karlarao@xxxxxxxxx>
  • To: "shastry17@xxxxxxxxx" <shastry17@xxxxxxxxx>
  • Date: Tue, 7 Jun 2011 06:55:56 -0500

Anantha,

I would use the sqltxplain on the good and bad plan..
and use the "compare" facility to show you what are the things that changed..


-Karl Arao


-- 
Karl Arao
karlarao.wordpress.com
karlarao.tiddlyspot.com
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 06-2011