Re: SIEBEL performance help wanted

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Tue, 15 Jan 2002 14:26:50 GMT
Message-ID: <3c443bd1.1949019@news-vip.optusnet.com.au>

Andy doodled thusly:

>
>The SIEBEL consultant (hah!) isn't any good, all he knows about are a
>couple of initialisation parameters.

Typical.

>
>For further info:
>
>Oracle V8163 on Solaris
>shared_pool_size = 600M
>8k block size
>sort area size=500m
>sort area retained size=250M
>
>Any ideas? Please? Help me...

Check out if hash joins are enabled. Turn them off if so. I know, they are not allowed in RULE, but indulge me: turn them OFF specifically through init.ora.

See if that improves the use of indexes.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Tue Jan 15 2002 - 08:26:50 CST