Re: event "Network file transfer"

Niall, Mladen, Rich, Sayan, Jonathan, Matt, and Nenad,

Thanks so much for all of the responses!  I've sent Nenad's query to the customer (yes, they're licensed), and I am hopeful that they will respond promptly.  Of course, whatever is received will be shared.  More soon...

Thanks again!

-Tim

On 9/10/2020 1:38 AM, dimensional.dba_at_comcast.net wrote:
>
> Or are you using remote locations for your archive logs?
>
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>
> *On Behalf Of *dimensional.dba_at_comcast.net
> *Sent:* Thursday, September 10, 2020 12:50 AM
> *To:* jlewisoracle_at_gmail.com; 'ORACLE-L' <oracle-l_at_freelists.org>
> *Subject:* RE: event "Network file transfer"
>
> Do you have a Data Guard database associated to this database?
>
> *From:* oracle-l-bounce_at_freelists.org
> <mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org
> <mailto:oracle-l-bounce_at_freelists.org>> *On Behalf Of *Jonathan Lewis
> *Sent:* Wednesday, September 9, 2020 11:23 PM
> *To:* ORACLE-L <oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>>
> *Subject:* Re: event "Network file transfer"
>
> Ignore my previous comment.
>
> I've done some searching and the "new event" was something about
> "vector data to/from client", not about file transfer
>
> Regards
>
> Jonathan Lewis
>
> On Wed, Sep 9, 2020 at 11:02 PM Tim Gorman <tim.evdbt_at_gmail.com
> <mailto: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