Re: Calling out DBA tuning experts

Are you engaging Oracle's cost based optimizer and subsequently running 'the batch'?

Brian + Susan McCracken wrote:

> I have recently upgraded from 7.2.3 to 7.3.4
>
> The batch is now taking 50% longer to complete.
>
> The tkprof out put from both 7.3.4 and 7.2.3 show almost equivalent times
> for total elapsed time despite the fact that 7.3.4 takes 50% longer.
>
> This mark up is consistent throughout.
>
> I believe the proble may be related to a relationship beteen the Oracle
> processes and the HP-UX 10.20 OS.
>
> A bstat/estat was produced for both versions of the database and thye
> significant difference was detected in the session event
>
> rdbms ipc message statistics which was 6 times greater in overall elapsed
> time
>
> Does anyone have any info on this statistic and what it means.
Received on Fri Jan 08 1999 - 18:08:24 CST