Re: Trace File Question: WAIT_TIME = what? Seconds? Centiseconds?
- From: Ryan January <rjjanuary@xxxxxxxxxxxxxxxx>
- To: Christopher.Taylor2@xxxxxxxxxxxx
- Date: Thu, 11 Apr 2013 11:05:06 -0500
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@xxxxxxxxxxxx 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
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
