topic Re: v$session_wait in Operating System - HP-UX

v$session_wait

ericfjchen — Mon, 13 Dec 2004 22:05:32 GMT

Where can I get a complete reference guide for all session wait event?

Thanks

Eric

Re: v$session_wait

Indira Aramandla — Mon, 13 Dec 2004 22:39:00 GMT

Hi Eric,

Here is something from Metalink.

Indira A

Re: v$session_wait

ericfjchen — Mon, 13 Dec 2004 22:47:32 GMT

Hi Indira A,

Thanks. However I don't just want to know the definition of v$session_wait. We are using Oracle 9014. There are 291 session wait events in it. We want to realize all kinds of wait events meaning. Where can I get the white paper about it?

For example, we are meeting a wait event now. This session is waiting for "transactin" more than 3 hours. It is still hung. However, we can't get more useful information till now.

Thanks again

Eric

Re: v$session_wait

Indira Aramandla — Mon, 13 Dec 2004 23:43:49 GMT

Hi Eric,

Appendix in the Oracle9i Reference manual contains descriptions of the Oracle Wait Events

There are articles available from the MetaLink Doc ID: 62161.1 Systemwide Tuning using UTLESTAT .

Attached is the white paper â Introduction to Tuning Oracle7 / Oracle8 / 8i / 9â .

In

Re: v$session_wait

Eric Antunes — Tue, 14 Dec 2004 04:41:41 GMT

Hi Eric,

Execute the following:

select substr( ln.name, 1, 30), gets, misses,
misses/decode( gets, 0, 9999999999999, gets)*100 misses_gets_ratio,
immediate_misses/decode( immediate_gets, 0, 9999999999999, immediate_gets)*100 immediate_misses_gets_ratio,
immediate_gets, immediate_misses
from v$latch l, v$latchname ln
where
ln.latch# = l.latch#
order by 5 desc

This will show you latch contention. Post here the first 5 rows and I will try to help you.

Regards,

Eric Antunes

Re: v$session_wait

Patti Johnson — Tue, 14 Dec 2004 09:33:14 GMT

In addition to the Oracle manuals you might want to check out the following websites.
http://www.hotsos.com
http://www.ixora.com.au/
Cary Millsap and Steve Adams both have excellent tuning books and provide details on Oracle Internals that are difficult to find elsewhere.

Patti