''TCP Socket (Kgas)'' Waits Present in 10.2 [ID 416451.1]
来源:互联网 发布:电影特效制作软件 编辑:程序博客网 时间:2024/05/27 21:11
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 Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.1 - Release: 10.1 to 10.2Information 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.References
BUG:5490208 - TIME WAIT TCP SOCKET KGAS
- ''TCP Socket (Kgas)'' Waits Present in 10.2 [ID 416451.1]
- Higher 'direct path read' Waits in 11g when Compared to 10g (Doc ID 793845.1)
- Troubleshooting 'enq: TX - index contention' Waits in a RAC Environment. (文档 ID 873243.1)
- high "latch: cache buffers chains" waits in 10.2.0.3 DB
- Implicit & Explicit Waits in Selenium
- TCP socket, select model in linux.
- TCP socket, select model in linux
- TCP Socket 简单编程 in java
- TCP/IP Socket Communications in MATLAB example
- Troubleshooting: Waits for Mutex Type Events (文档 ID 1377998.1)
- Troubleshooting 'library cache: mutex X' waits. (文档 ID 1357946.1)
- WAITEVENT: "buffer busy waits" Reference Note (文档 ID 34405.1)
- WAITEVENT: "buffer busy waits" Reference Note (Doc ID 34405.1)
- Troubleshooting 'library cache: mutex X' Waits. (文档 ID 1357946.1)
- Troubleshooting 'library cache: mutex X' waits. (文档 ID 1357946.1)
- TCP/IP socket programming in C(一)
- TCP/IP socket programming in C(二)
- TCP/IP socket programming in C(三)
- STL容器之multimap和multiset
- 嘿牛程序员_成都传智博客_讨论字符串中字符出现的次数(续二:通过对象列表实现按次序输出)
- 学习计划
- VC++ MFC 定时器应用
- Android应用程序的生命周期
- ''TCP Socket (Kgas)'' Waits Present in 10.2 [ID 416451.1]
- Android动画概要---Animation Overview
- 12 个网络监控工具
- setsockopt设置socket状态
- Financial Level Version Calculation
- 为什么是数据结构?
- EXTASP.NET绑定数据显示不出来
- MATLAB学习总结——严格对应函数调用格式(2012.06.28)
- MFC应用程序中指针的使用