Re: SIEBEL performance help wanted

From: Stefan <sroesch3_at_attbi.com>
Date: Tue, 15 Jan 2002 05:40:42 GMT
Message-ID: <uhP08.31829$JF.312878@rwcrnsc52.ops.asp.att.net>

Hi Andy,

who has advised to set optimizer_index_cost_adj. If it was the Siebel guy than tell him it makes no sense. This only changes the behaviour if using CBO.

Post the sql statement and the execution plan to see if we can help you. But most of the times the bad design can't be fixed in the last stage by the DBA.

Stefan

Andy wrote:

> More info:
>
> optimizer_mode=rule (siebel won't let us use cost/choose; no
> point in analyzing tables
>
> db_block_buffers=97656
> hash_area_size = 50000000
> hash_join_enabled = TRUE
> log_buffer = 104857600
> optimizer_index_cost_adj=10
>
>
> Also, the Siebel guy said we can't use hints.
>
> Furthermore, some tables have over 20 indexes on them (the record is
> 33) and the Siebel guy says we shouldn't drop any.
Received on Mon Jan 14 2002 - 23:40:42 CST