Re: How to get the SQL query of a blocking sid during a lock contention

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Mon, 11 Jul 2005 18:37:03 -0700
Message-ID: <-4OdnX0YF6Lig07fRVn-hA@comcast.com>

<darthmind_at_gmail.com> wrote in message
news:1121098211.210719.294000_at_g47g2000cwa.googlegroups.com...
> We need to identify the SQL query a process is executing that's
> creating a lock contention; how do we do that? For example, with MSS
> one can do 'DBCC INPUTBUFFER(spid)'
>
> tia
>
> -t
>

Remember unlike SQL Server in Oracle readers don't block writers and writers don't block readers. (and readers don't block readers) Jim Received on Mon Jul 11 2005 - 20:37:03 CDT

This message: [ Message body ]
Next message: evoradba_at_yahoo.ca: "ORA-12545 Connect failed because target host or object does not exist"
Previous message: David E. Grove: "10g patchset 10.1.0.4"
In reply to: darthmind_at_gmail.com: "How to get the SQL query of a blocking sid during a lock contention"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US