Re: Calling out DBA tuning experts

That's what I badly would wan't to know also. The same problem seems to applies to AIX 4.2.1 also. The only thing I could find in Oracle websites was that this statistic is meaningless. Yet my utlestat output showed an average ipc wait time of 60 secs!

Thanks,

Sybrand Bakker, Oracle DBA

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 - 15:04:48 CST