Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

v$active_session_history.wait_time

556627Jan 13 2009 — edited Jan 15 2009

Hi,

Does anyone know scale of wait_time/time_waited columns in v$active_session_history (or in DBA_HIST_ACTIVE_SESS_HISTORY) view - millisecs/microsecs/nanosecs ?

I'd also like to know how to interpret those values.

For example, we have a session that's waiting on "enq: TX ..." for almost 10 minutes ... and time_waited has a value of about 489000 for each row in DBA_HIST_ACTIVE_SESS_HISTORY. So what's the actual time waited for this wait event?

SAMPLE_TIME SESSION_ID EVENT TIME_WAITED
-------------------------------------- ----------------- -------------------------------------------- ---------------------
13/01/09 11:31:05,287 279 enq: TX - row lock contention 489002

....

13/01/09 11:40:16,442 279 enq: TX - row lock contention 488865

Thank you,

Mirjana

This post has been answered by Jonathan Lewis on Jan 13 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 12 2009

Added on Jan 13 2009

#general-database-discussions

8 comments

3,250 views