Need clarification on the meaning of Performance Analysis showing production having high network waits workload
This is the time spent waiting for messages to be sent or received over the network interface.
Network performance is measured in number (per second) of packets sent and received. SQL*Net is the Oracle network interface that allows Oracle tools running on network workstations and servers to access, modify, share, and store data on other servers. SQL*Net is considered part of the program interface in network communications.
Network statistics can be used in much the same way as disk statistics to determine if a network or network interface is overloaded or not performing optimally.
Excessive network wait can be caused by either:
Excessive network usage originating in the application
Physical problems, identifiable by network errors and network collisions