One of our dev database has a large number of TCP Socket (KGAS) event waits when a piece of PL/SQL code runs.
from v$active_session_history active_session_history
where active_session_history.sample_time between
sysdate - 120/2880 and sysdate
group by active_session_history.event
order by 2 desc;
TCP Socket (KGAS) 843316255
log file sync 1912981
I check the Oracle reference of TCP Socket wait events, it says,
KGAS is a component in the server which handles TCP/IP sockets which is typically used in dedicated connections in 10.2+ by some
PLSQL built in packages such as UTL_HTTP and UTL_TCP.
However, in this particular piece of code, there's no such package called, Momen blogged about the same event when he's using SMTP package. But it looks like this doesn't apply to us.
I then looked into metalink, I found this Doc,
''TCP Socket (Kgas)'' Waits Present in 10.2
It basically says this event is merely reporting some network related event, it's not threatening performance. The conclusion is this event can be safely ignored :D
Well, I hope Oracle could have fixed the bug in 10.2.0.4 and 11g, so that reporting of event in more DBA comforting method.