Re: wait events made WITHIN/BETWEEN database calls

On Tue, 13 Jul 2004 08:40:45 +0900, "Joe" <yung103_at_netvigator.com> wrote:

>I am reading the Optimizing Oracle Performance from O'reilly.
Written by Cary Millsap. That's the book Sybrand was referring to. The one many of us have on our desks at the moment. The one whose author replied to your op.

>In the book, it says
>

>
>--------------------------------------------------------------------------------

<lengthy snippage>
>
>--------------------------------------------------------------------------------
Good grief! You had time to key all that in?
>
>
>I have highlighted the related sentences in red.
>

Which doesn't come through on a text-only newsgroup --- at least not with text-only news readers.
>
>Joe
>
>
>
>
>
>"Sybrand Bakker" <sybrandb_at_hccnet.nl> ??? news:plh5f01qtblatk7r18fp926s79akplmbl5_at_4ax.com ???...
>> On Mon, 12 Jul 2004 20:21:46 +0900, "Joe" <yung103_at_netvigator.com>
>> wrote:
>>
>> >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
>> >
>>
>> You must be reading the Millsap book. As far as I am concerned, he
>> DOES explain it.
>> Wait events with a database calls is anything your session is waiting
>> for while processing a fetch.
>> Wait events between database calls is mainly the Oracle session
>> waiting for the client to come up with a new statement. Yes, that the
>> sqlnet waiting message from client events.
>>
>>
>> --
>> Sybrand Bakker, Senior Oracle DBA
Received on Fri Jul 16 2004 - 07:38:36 CDT