1748156 Members
3826 Online
108758 Solutions
New Discussion юеВ

Re: v$session_wait

 
ericfjchen
Regular Advisor

v$session_wait

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

Thanks

Eric
5 REPLIES 5
Indira Aramandla
Honored Contributor

Re: v$session_wait

Hi Eric,

Here is something from Metalink.

Indira A
Never give up, Keep Trying
ericfjchen
Regular Advisor

Re: v$session_wait

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
Indira Aramandla
Honored Contributor

Re: v$session_wait

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
Never give up, Keep Trying
Eric Antunes
Honored Contributor

Re: v$session_wait

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
Each and every day is a good day to learn.
Patti Johnson
Respected Contributor

Re: v$session_wait

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