%Time -outs or TOTAL_TIMEOUTS column in DBA_HIST_SYSTEM_EVENT column

From: kunwar singh <krishsingh.111_at_gmail.com>
Date: Fri, 19 Apr 2019 04:09:34 -0400
Message-ID: <CAJSrDUpWmrxtHo66WAG2XtKGnJJ8K6ka9azSmDYzzppPXqHA_w_at_mail.gmail.com>

Hey there Listers,
I have an academic sort of question and trying to understand if it can solve a problem that we are facing using this column.

*Question*:

In what all scenarios can the column TOTAL_TIMEOUTS be helpful in performance analysis.
Normally i use TOTAL_WAITS and TIME_WAITED_MICRO and that is sufficient , but i am investigating a timeout related issue at the application end and want to know if this can be useful.

For example this section in the AWR report:

Foreground Wait Events

Event                 Waits %Time -outs Total Wait Time (s) Avg wait Waits
/txn % DB time
direct path write temp 40,090         138 3.44ms 0.08 3.63
Failed Logon Delay     2     100         2 1001.62ms 0.00 0.05
TCP Socket (KGAS)     42     24         1 17.54ms 0.00 0.02
 <<<<<<<<<<<<<<<<<<<<<<<<<< %Time-outs of 24

See the 24 timeouts for TCP Socket(KGAS) .
*note: My question is not specific to TCP * wait , but in general *

Apologies if this is a silly question :) , but to be honest i have never used this column for any troubleshooting.

-- 
Cheers,
Kunwar

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Apr 19 2019 - 10:09:34 CEST