Doc ID 416451.1 "What are 'TCP Socket (Kgas)' Waits?" from Oracle support explains:
A session is waiting for an external host to provide requested data over a network socket. The time that this wait event tracks does not indicate a problem, and even a long wait time is not a reason to contact Oracle Support.
and
An application that communicates with a remote host must wait until the data it will read has arrived.
The db session cannot proceed to do anything else until the external host provides the requested data over the network socket.
The proposed "solution":
From the database point of view, these waits can safely be ignored; the wait event does not represent a database issue. It merely reports the total elapsed time for a network connection to be established or for data to arrive from over the network.
Check also Doc ID 558510.1 "WAITEVENT: "TCP Socket (KGAS)" Reference Note"
Minimalistic Oracle contains a collection of practical examples from my encounters with Oracle technologies. When relevant, I also write about other technologies, like Linux or PostgreSQL. Many of the posts starts with "how to" since they derive directly from my own personal experience. My goal is to provide simple examples, so that they can be easily adapted to other situations.
Showing posts with label Waits. Show all posts
Showing posts with label Waits. Show all posts
Monday, June 4, 2018
Subscribe to:
Comments (Atom)