Re: event "Network file transfer"

I *think* that's rman network duplicate or dbms_file_transfer related. I have seen it, but not in my current job so digging out notes might be challenging.

On Wed, Sep 9, 2020 at 11:03 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
>
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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