Re: Help on understanding TKprof

On 6 Jan 2006 14:35:49 -0800, "Melgar" <luis_melgar_at_yahoo.com> wrote:

>on the other hand i had run a utlstats report and i notice that rdbms
>ipc message avg time its huge.
>
>what rdbms ipc message means?
>
>Event Name Count Total Time Avg Time
>
>-------------------------------- ------------- -------------
>-------------
>SQL*Net message from client 736119 7846568
>10.66
>rdbms ipc message 182 1068142
>5868.91
>db file sequential read 850280 774935
>.91
>pipe get 1094 529888
>484.36

ipc = interprocess communication
rdbms ipc : communication between the various Oracle related processes.
Oracle considers this to be an idle event which is irrelevant for any tuning.

--
Sybrand Bakker, Senior Oracle DBA