Re: v$sql.elapsed_time
From: Hemant K Chitale <hemantkchitale_at_gmail.com>
Date: Mon, 8 Dec 2014 08:12:53 +0800
Message-ID: <CAMNBsZtH+hTwoHoF82rUCnL3Gwj9tEoqJ05cnD4noF9_wBUBaQ_at_mail.gmail.com>
I believe that it does include sql net message time when many rows are being returned to the client using multiple FETCH calls.
Date: Mon, 8 Dec 2014 08:12:53 +0800
Message-ID: <CAMNBsZtH+hTwoHoF82rUCnL3Gwj9tEoqJ05cnD4noF9_wBUBaQ_at_mail.gmail.com>
I believe that it does include sql net message time when many rows are being returned to the client using multiple FETCH calls.
Sent from my smart phone.
Hemant K Chitale
On 05-Dec-2014 10:24 PM, "Zwettler Markus (OIZ)" <Markus.Zwettler_at_zuerich.ch>
wrote:
> Hi,
>
>
>
> Afaik, v$sql.elapsed_time does _*not*_ include idle wait times like
> SQL*NET waits (sqlnet message to/from client; sqlnet roundtrips to/from
> client). Agreed?
>
>
>
> Regards, Markus
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Dec 08 2014 - 01:12:53 CET