RE: OPTIMIZER MODE
- From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
- To: "lambu999@xxxxxxxxx" <lambu999@xxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 6 Jul 2010 13:37:30 +0200
Cary Millsap and Jeff Holt have written an excellent book about this:
Optimizing Oracle Performance
Regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Ram K
Sent: dinsdag 6 juli 2010 13:18
To: oracle-l
Subject: OPTIMIZER MODE
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
