Re: Serious Issue in oracle

From: Thomas Roach <troach_at_gmail.com>
Date: Tue, 26 Jan 2010 09:30:42 -0500
Message-ID: <b86ffce61001260630k3a360727y555525ce27df41c4_at_mail.gmail.com>



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_at_environment-agency.gov.uk> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Thomas Roach
813-404-6066
troach_at_gmail.com

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 26 2010 - 08:30:42 CST

Original text of this message