Re: event "Network file transfer"

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
>
>
>
>
>
>
>
>
>

-- 
Mladen Gogala

Database Consultant

Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l