- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: v$session_wait
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-13-2004 02:05 PM
тАО12-13-2004 02:05 PM
v$session_wait
Thanks
Eric
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-13-2004 02:39 PM
тАО12-13-2004 02:39 PM
Re: v$session_wait
Here is something from Metalink.
Indira A
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-13-2004 02:47 PM
тАО12-13-2004 02:47 PM
Re: v$session_wait
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-13-2004 03:43 PM
тАО12-13-2004 03:43 PM
Re: v$session_wait
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-13-2004 08:41 PM
тАО12-13-2004 08:41 PM
Re: v$session_wait
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-14-2004 01:33 AM
тАО12-14-2004 01:33 AM
Re: v$session_wait
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