tag:blogger.com,1999:blog-1755315926100938840.post2760999286485009020..comments2024-03-28T15:16:06.294+03:00Comments on Erman Arslan's Oracle Blog: EBS 12.2 -- TCP Socket (KGAS) waitErman Arslanhttp://www.blogger.com/profile/07686231074805634082noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-1755315926100938840.post-42487973087650151032016-08-27T11:24:21.846+03:002016-08-27T11:24:21.846+03:00There was a trigger which was trying to send email...There was a trigger which was trying to send emails in every insert or update operation. So, when there is a high count of inserts, it was causing the issue. In our case, the trigger was disabled and optimized in a way to decrease the TCP kgas waits.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1755315926100938840.post-57024544299936177352016-08-26T21:10:09.114+03:002016-08-26T21:10:09.114+03:00What was the code fix that was performed as I have...What was the code fix that was performed as I have the same issue now. Th code hasbeen running for 9 years without a problem.p2lm98https://www.blogger.com/profile/13610264623067671146noreply@blogger.comtag:blogger.com,1999:blog-1755315926100938840.post-33673472119972867982016-06-19T11:09:57.186+03:002016-06-19T11:09:57.186+03:00It was quiet useful link.It was quiet useful link.Unknownhttps://www.blogger.com/profile/05649938702803317419noreply@blogger.com