Re: event "Network file transfer"

Hey Tim,

It's not even documented in 19: Descriptions of Wait Events <https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/descriptions-of-wait-events.html>, although it appears that most of the actual entries in the view are also not documented.

I'm still waiting 2+ months for documentation on the values of the OBJ_PRIVILEGE column of DBA_AUDIT_TRAIL (SR escalated a month ago), so I hope you have better luck...

Rich

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