Re: i/o parameters on oracle and sun

From: Viacheslav Leichinsky <v_leichinsky_at_ittoolbox.com>
Date: Wed, 17 Jan 2001 06:57:51 GMT
Message-ID: <943fpd$8ob$1@nnrp1.deja.com>

In article <3A643625.979_at_yahoo.com>,
connor_mcdonald_at_yahoo.com wrote:
> Yes - the larger the multiblock the more scans tend to be preferred.
If
> you're app has more of dependency on nested loop performance, then
could
> consider an optimiser mode of first_rows in init.ora or selected
> sessions.

Hello,

you mustn't set optimiser_mode=first_rows in init.ora because queries on SYSTEM tablespace have optimized for RBO (not CBO).

Regards,
Slava.

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 17 2001 - 00:57:51 CST