Re: Calling out DBA tuning experts

Post more infomation related this issue, I might have a solution for you. Can you identify which sql stmt cuase the slowness?

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 Sat Jan 09 1999 - 22:30:30 CST