Trace File Question: WAIT_TIME = what? Seconds? Centiseconds?
- From: <Christopher.Taylor2@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 11 Apr 2013 10:40:06 -0500
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
Other related posts:
