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

From: Karl Arao <karlarao_at_gmail.com>
Date: Tue, 7 Jun 2011 06:55:56 -0500
Message-ID: <BANLkTinG6Cf_i5QO=7_WynaXz0Bx=yo=fg_at_mail.gmail.com>

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
--

http://www.freelists.org/webpage/oracle-l Received on Tue Jun 07 2011 - 06:55:56 CDT

This message: [ Message body ]
Next message: P D: "RE: How get everything back in sync after manual removal of archivelogs"
Previous message: Igor Racic: "Re: What utilities/tools do you use to Organize Oracle Articles/Tips?"
In reply to: Shastry(DBA): "Performance issue post database analyze, need to understand whats wrong in analyze"
Next in thread: Jorgensen, Finn: "RE: Performance issue post database analyze, need to understand whats wrong in analyze"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message