Re: event "Network file transfer"

There are several scenarios which include sending files over the network: * OEM agent sending XML files to the OEM server

• Standby databases
• dbms_file_transfer I verified that GG is not the culprit. And yes, Oracle's documentation of the wait events leaves some room for the improvement.RegardsOn Wed, 2020-09-09 at 19:26 -0500, Rich J wrote:
  > Hey Tim,
  >
  >
  > It's not even documented in 19: Descriptions of Wait Events, although
  > it appears that most of the actual entries in the view are also not
  > documented.
  >
  >
  > I'm still waiting 2+ months for documentation on the values of the
  > OBJ_PRIVILEGE column of DBA_AUDIT_TRAIL (SR escalated a month ago),
  > so I hope you have better luck...
  >
  > Rich
  >
  > On Wed, Sep 9, 2020 at 5:02 PM Tim Gorman <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
  > >
  > >
  > >
  > >
  > >
  > >
  > >
  > >
  > >
  -- Mladen Gogala

Database Consultant

Tel: (347) 321-1217

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