OPTIMIZER MODE
From: Ram K <lambu999_at_gmail.com>
Date: Tue, 6 Jul 2010 06:17:34 -0500
Message-ID: <AANLkTimc539GtMpQMFRklgjP3rXcDlneEUD9_L5NbdWo_at_mail.gmail.com>
Listers,
Date: Tue, 6 Jul 2010 06:17:34 -0500
Message-ID: <AANLkTimc539GtMpQMFRklgjP3rXcDlneEUD9_L5NbdWo_at_mail.gmail.com>
Listers,
We have a new 11g based hybrid application that a third party vendor is configuring. We observe some slowness in the response times. I do not see any slow sql in v$sql. The vendor is recommending that we set the OPTIMIZER_MODE to FIRST_ROWS to get better response times, among other parameter changes. I have read in few sources that FIRST_ROWS is not generally used, with oracle itself using ALL_ROWS. Can anyone advise?
--
Thanks,
Ram.
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 06 2010 - 06:17:34 CDT