Norman, You are right, I mispoke. I use this view to see blocking sessions which is something you would see before a deadlock occurrs (depending on how quick the deadlock occurs). Cheers, Tom On Tue, Jan 26, 2010 at 3:15 AM, Dunbar, Norman < norman.dunbar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote: > Morning Thomas, > > >> Yep, query gv$session and filter based on username, > >> schemaname, and sql_id if you know it. Pay close attention > >> to the event and blocking session columns. That will tell > >> you if there is some sort of deadlock occurring. > > I'm puzzled. I've never seen a deadlock show up in V$SESSION or > V$SESSION_WAIT before. Any deadlock I've actually seen - I've set up > myself for testing purposes - usually has one statement killed by Oracle > and an ORA-60 reported within a second and well before I get a chance to > check these views. > > I know a second is a long time CPU wise, but I'm not all that sure that > a deadlock will show up in either of these views. I'm interested though > in knowing whether it does or doesn't - in case anyone has seen them > show up. > > I've got a blog entry on deadlocks at > http://qdosmsq.dunbar-it.co.uk/blog/?p=192 and I'd like to keep it up to > date. > > > Cheers, > Norman. > > > Information in this message may be confidential and may be legally > privileged. If you have received this message by mistake, please notify the > sender immediately, delete it and do not copy it to anyone else. We have > checked this email and its attachments for viruses. But you should still > check any attachment before opening it. We may have to make this message and > any reply to it public if asked to under the Freedom of Information Act, > Data Protection Act or for litigation. Email messages and attachments sent > to or from any Environment Agency address may also be accessed by someone > other than the sender or recipient, for business purposes. If we have sent > you information and you wish to use it please read our terms and conditions > which you can get by calling us on 08708 506 506. Find out more about the > Environment Agency at www.environment-agency.gov.uk > > Information in this message may be confidential and may be legally > privileged. If you have received this message by mistake, please notify the > sender immediately, delete it and do not copy it to anyone else. > > We have checked this email and its attachments for viruses. But you should > still check any attachment before opening it. > We may have to make this message and any reply to it public if asked to > under the Freedom of Information Act, Data Protection Act or for litigation. > Email messages and attachments sent to or from any Environment Agency > address may also be accessed by someone other than the sender or recipient, > for business purposes. > > If we have sent you information and you wish to use it please read our > terms and conditions which you can get by calling us on 08708 506 506. Find > out more about the Environment Agency at www.environment-agency.gov.uk > -- > //www.freelists.org/webpage/oracle-l > > > -- Thomas Roach 813-404-6066 troach@xxxxxxxxx