Re: Trace File Question: WAIT_TIME = what? Seconds? Centiseconds?

From: Ryan January <rjjanuary_at_multiservice.com>
Date: Thu, 11 Apr 2013 11:05:06 -0500
Message-ID: <5166DF32.3030306_at_multiservice.com>

I can't seem to get to metalink currently, however I believe wait_time is measured in centiseconds. In your "waiting for" line it's showing "wait_time=0" signifying that the session is currently in wait, and the number of seconds since wait started (16 at this point). If it's of any benefit the measurement within the file should be the same as what can be found in v$session_wait. It shouldn't be too difficult to reverse engineer for verification.

Thanks,
Ryan

On 04/11/2013 10:40 AM, Christopher.Taylor2_at_parallon.net wrote:
> Just a quick question, in a trace file sample below, what is the wait_time measured in? Clearly it's not seconds unless I have a serious problem...
> (I tried finding the answer on Metalink but searching for this specific question is hard to get the results I needed)
>
>
> SO: 0x18347e0de8, type: 4, owner: 0x183ede9958, flag: INIT/-/-/0x00
> (session) sid: 5321 trans: 0x17f4e15ce0, creator: 0x183ede9958, flag: (40000045) USR/- BSY/-/-/-/-/-
> DID: 0001-008A-000005EE, short-term DID: 0000-0000-00000000
> txn branch: (nil)
> oct: 189, prv: 0, sql: 0x16ee592400, psql: 0x16c4dd9240, user: 92/CONCUITY
> service name: xxxxx
> O/S info: user: xxxxx, term: unknown, ospid: , machine: xxxxxxx
> program: xxxx
> application name: xxxxx, hash value%46894660
> waiting for 'enq: TM - contention' blocking sess=0x(nil) seq8 wait_time=0 seconds since wait started16
> name|modeT4d0004, object #;1cd, table/partition=0
> Dumping Session Wait History
> for 'enq: TM - contention' count=1 wait_time24204
> name|modeT4d0004, object #;1cd, table/partition=0
> for 'enq: TM - contention' count=1 wait_timeH9265
> name|modeT4d0004, object #;1cd, table/partition=0
> for 'enq: TM - contention' count=1 wait_timeH9258
> name|modeT4d0004, object #;1cd, table/partition=0
> for 'enq: TM - contention' count=1 wait_timeH9273
> name|modeT4d0004, object #;1cd, table/partition=0
> for 'enq: TM - contention' count=1 wait_timeH9262
> name|modeT4d0004, object #;1cd, table/partition=0
> for 'enq: TM - contention' count=1 wait_timeH9264
> name|modeT4d0004, object #;1cd, table/partition=0
> for 'enq: TM - contention' count=1 wait_timeH9265
> name|modeT4d0004, object #;1cd, table/partition=0
> for 'enq: TM - contention' count=1 wait_timeH9258
> name|modeT4d0004, object #;1cd, table/partition=0
> for 'enq: TM - contention' count=1 wait_timeH9276
> name|modeT4d0004, object #;1cd, table/partition=0
> for 'enq: TM - contention' count=1 wait_timeH9255
> name|modeT4d0004, object #;1cd, table/partition=0
> temporary object counter: 0
>
> Chris Taylor
> Oracle DBA
> Parallon IT&S
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

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

Received on Thu Apr 11 2013 - 18:05:06 CEST