Re: Session Allocation latch contention - limiting concurrent SQL
- From: Martic Zoran <zoran_martic@xxxxxxxxx>
- To: scott.hutchinson@xxxxxxxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 10 Feb 2005 06:44:58 -0800 (PST)
Scott,
just an add-on questions on top of the previous mail:
Did you do tracing with level 10046 or just queried
system/session stats?
Which system/session wait you are saying is the
problem here?
How did you get to the point to look wait_time for
v$latch and pointing these latches are the biggest
problem (from which waits, statistics)?
Regards,
Zoran
__________________________________
Do you Yahoo!?
Yahoo! Mail - now with 250MB free storage. Learn more.
http://info.mail.yahoo.com/mail_250
--
//www.freelists.org/webpage/oracle-l
Other related posts:
