Quick Exam Finder Q & A
Keyword :
Loading
keyword like EXAM CODE, EXAM NAME, VENDOR NAME...
''TCP Socket (Kgas)'' Waits Present in 10.2
Ads
Database
Symptoms

You received this message in OEM Grid for an Oracle 10G R2 database and would like to know what it means:

Investigate the cause for high "TCP Socket (KGAS)" waits. Refer to Oracle's "Database Reference" for the description of this wait event.

Cause

The wait event you have reported is basically newly reported in version 10.2 and newer. The appearance of the message was reported in published Bug 5490208. The bottom line is that the event is reporting network perfomance as follows:

"The db session cannot proceed to do anything else until the external host provides the requested data over the network socket. "

It is reported also that using shared server connections will cause the message to disappear.

Solution

It is not degrading performance but merely reporting the wait event so it can safely be ignored.
References

BUG:5490208 - TIME WAIT TCP SOCKET KGAS
 
Ads