Do you have a Data Guard database associated to this database?
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On Behalf
Of Jonathan Lewis
Sent: Wednesday, September 9, 2020 11:23 PM
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxx
<mailto:tim.evdbt@xxxxxxxxx> > 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