Re: event "Network file transfer"

Tim,

I'm not certain, but I think I've seen this starting to appear in newer versions of Oracle when Securefile LOBs are being sent to the client.

Regards
Jonathan Lewis

On Wed, Sep 9, 2020 at 11:02 PM Tim Gorman <tim.evdbt_at_gmail.com> wrote:

> Friends,
>
> I'm seeing an event named "Network file transfer" in an AWR report, and I
> don't recall ever having seen it previously. Database is 12.2.0.1.0 on
> RHEL 7.8...
>
> *Top 10 Foreground Events by Total Wait Time*
>
> Event Waits Total Wait Time (sec) Avg Wait % DB time Wait Class
> SQL*Net more data to client 1,037,437 39K 37.61ms 9.6 Network
> Network file transfer 1,033,978 26.1K 25.26ms 6.4 System I/O
> DB CPU 4118 1.0
> db file sequential read 11,033 2355.4 213.48ms .6 User I/O
> db file scattered read 2,889 511.4 177.02ms .1 User I/O
> log file sync 1,391 163.7 117.66ms .0 Commit
> control file sequential read 1,140 8.6 7.57ms .0 System I/O
> log file switch completion 2 7.8 3916.40ms .0 Configuration
> db file parallel read 65 6.1 94.46ms .0 User I/O
> Sync ASM rebalance 300 2 6.70ms .0 Other
>
>
> It is challenging to find information because search keywords like "oracle
> event network file transfer" returns a lot of unrelated stuff.
>
> Does anyone have any links or information on this event and what it
> represents?
>
> Thanks!
>
> -Tim
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l