event "Network file transfer"
Date: Wed, 9 Sep 2020 15:01:05 -0700
Message-ID: <eb158b70-1a99-6096-1c33-faa1d3e1cc16_at_gmail.com>
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*
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
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
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 10 2020 - 00:01:05 CEST