Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: wait events made WITHIN/BETWEEN database calls
Joe,
"Between-call" events are recognizable by name. See page 88 for a list of names of between-call events. If an event has a name other than one of these names, then the chances are excellent that it is a "within-call" event.
Once you've made this distinction, you can use the following insight:
Cary Millsap
"Joe" <yung103_at_netvigator.com> wrote in message
news:cctvon$gc82_at_imsp212.netvigator.com...
> Hi All,
>
> I am reading a performance tuning book, in which I come across the terms
> 1. wait events made within database calls
> 2. wait events made between database calls
> when walking through the extended SQL trace output.
>
> Can anyway explain to me how to distinguish the 2 database calls from each
> other?
>
> Thanks in advanced.
>
> Joe
>
>
Received on Mon Jul 12 2004 - 21:47:12 CDT