"Daud" <daud11_at_hotmail.com> wrote in message
news:f0bf3cc3.0404230000.45cb9d49_at_posting.google.com...
> Before I run dbms_stats I normally change the sort_area_size for the
> session to 100M. Will this have an effect on the execution plan that
> will be generated later? I should not think so but I just need a
> confirmation.
>
> Daud
Assuming you change it back, or end the session then no it won't affect the
execution plan - the stats gathered will be the same.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
http://www.niall.litchfield.dial.pipex.com/
Received on Fri Apr 23 2004 - 03:10:24 CDT
