Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query performance dramatically different
One thing to investigate looks to me whether the sql*plus array size
settings are identical on affected systems. Oracle performs logical I/O
for every array being fetched. Which results in extra logical I/O if
array size is small.
I would also make sure everyone is running either FIRST_ROWS or
ALL_ROWS, and you don't have different optimizer strategies involved.
Just my 2 € cents.
-- Sybrand Bakker Senior Oracle DBAReceived on Wed Feb 01 2006 - 02:48:04 CST