Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> TCP Socket Wait event
dhanasekar.167
post Aug 6 2008, 09:34 AM
Post #1


Advanced Member
***

Group: Members
Posts: 48
Joined: 18-July 07
Member No.: 10,291



Hi,

In the Top 5 wait event of the awr report,i have a event named TCP Socket (KGAS).Can you please help me to resolve this and what is TCP Socket (KGAS)?

Thanks,
Dhanasekar
Go to the top of the page
 
+Quote Post
andrew kerber
post Aug 6 2008, 11:00 AM
Post #2


Advanced Member
***

Group: Banned
Posts: 489
Joined: 16-November 07
Member No.: 14,089



Usually that means Oracle is trying to send a mail message using utl_tcp or utl_smtp, and is having trouble connecting. You probably dont need to worry about it unless there are a lot of Oracle applications that are trying to send emails.
Go to the top of the page
 
+Quote Post
dhanasekar.167
post Aug 6 2008, 11:35 AM
Post #3


Advanced Member
***

Group: Members
Posts: 48
Joined: 18-July 07
Member No.: 10,291



QUOTE (andrew kerber @ Aug 6 2008, 09:31 PM) *
Usually that means Oracle is trying to send a mail message using utl_tcp or utl_smtp, and is having trouble connecting. You probably dont need to worry about it unless there are a lot of Oracle applications that are trying to send emails.



Hi Andrew


Thanks for you are response.i wil check in my application.
Go to the top of the page
 
+Quote Post
aussie_dba
post Aug 6 2008, 05:43 PM
Post #4


Advanced Member
***

Group: Members
Posts: 618
Joined: 28-August 04
Member No.: 495



"Can you please help me to resolve this and what is TCP Socket (KGAS)?"

Could it be because your mail server is down?

People say that TCP Socket (KGAS) is an Oracle application that uses DBMS_JOB to send out large amounts of emails, so it may be that it is waiting on the email server to respond.

You have two choices with TCP Socket (KGAS) waits, beef up your e-mail server or move the e-mails to another Oracle server.

Also see here on TCP Socket (KGAS).

http://momendba.blogspot.com/2007/03/tcp-s...wait-event.html

QUOTE
was experiencing waits on "TCP Socket (KGAS)" event. Upon investigation, we found out that it was because the mail server was down and the procedure tries to open a new connection with the SMTP server and it takes 75 seconds to timeout on IBM-AIX.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 31st October 2014 - 08:00 PM