Hi Ray, I found the same Investigue la causa del alto número de esperas de "TCP Socket (KGAS)" con P1,P2,P3 (" , , ") valores "6", "0" y "0" respectivamente.
Did you found what can it be, the datbase send several emails, so the cause could be email server too :)
Oracle 10.2
Red Hat AS 4
I am seeing a large amounts of time spent waiting for the event: TCP Socket (KGAS). This is an 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.
I'm just wondering if anyone has seen this one before, has any advice about it or knows what the KGAS refers to.
Thanks
Ray
-- ---------------------------------------- http://www.oracleboliviaspecialists.com/
Oracle Certified Profesional 9i 10g Orace Certified Professional Developer 6i