Hi Tim!I thought that the most likely scenario was Golden Gate, but I
tested and after replicating 5M records, not a single "network file
system" wait was encountered. I am as interested to find out as you
are.
020-09-09T19:33:53.873-0400 INFO OGG-06511 Oracle GoldenGate
Delivery for Oracle, rtgt1.prm: Using following columns in default map
by name: COL1, COL2.
2020-09-09T19:33:53.873-0400 INFO OGG-06510 Oracle GoldenGate
Delivery for Oracle, rtgt1.prm: Using the following key columns for
target table ORCLPDB1.SCOTT.TEST_TAB: COL1.
2020-09-09T19:35:37.966-0400 INFO OGG-01735 Oracle GoldenGate
Collector for Oracle: Synchronizing
/opt/oracle/product/19c/gg_home/./dirdat/lt000000037 to disk.
2020-09-09T19:35:37.976-0400 INFO OGG-01971 Oracle GoldenGate
Collector for Oracle: The previous message, 'INFO OGG-01735', repeated
3 times.
2020-09-09T19:35:37.976-0400 INFO OGG-01670 Oracle GoldenGate
Collector for Oracle: Closing
/opt/oracle/product/19c/gg_home/./dirdat/lt000000037.
2020-09-09T19:35:37.977-0400 INFO OGG-01669 Oracle GoldenGate
Collector for Oracle: Opening
/opt/oracle/product/19c/gg_home/./dirdat/lt000000038 (byte -1, current
EOF 0).
2020-09-09T19:35:38.556-0400 INFO OGG-02232 Oracle GoldenGate
Delivery for Oracle, rtgt1.prm: Switching to next trail file
/opt/oracle/product/19c/gg_home/dirdat/lt000000038 at 2020-09-09
19:35:38.556677 due to EOF. with current RBA 499,999,945.
I made sure that several trail files were delivered but that didn't
cause the wait event you mentioned.RegardsOn Wed, 2020-09-09 at 15:01
-0700, Tim Gorman 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