''TCP Socket (Kgas)'' Waits Present in 10.2 (Doc ID 416451.1)

rongshiyuan發表於2014-11-20

''TCP Socket (Kgas)'' Waits Present in 10.2 (Doc ID 416451.1)


In this Document

Symptoms
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.1 [Release 10.1 to 10.2]
Information in this document applies to any platform.
New wait event In database.
***Checked for relevance on 09-Nov-2011***


Symptoms

You received this wait event message in OEM Grid (or DBConsole) in the ASH (from v$active_session_history) 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 is basically new in version 10.2 and higher. The appearance of the message was discussed in published bug report Bug 5490208. The bottom line is that the event is reporting network performance 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

The wait event is not representing a degrading performance but merely reporting the event as such so it can safely be ignored.

 

Document Details

 
     
 

Related Products

 
     
 

Information Centers

 
     
 

Document References

 
No References available for this document.
     
 

Recently Viewed

 
     




來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-1340764/,如需轉載,請註明出處,否則將追究法律責任。

相關文章