RE: event "Network file transfer"

Do you have a Data Guard database associated to this database?    

From: oracle-l-bounce_at_freelists.org <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> 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