Re: Any way to know database lock?

Peter CCH wrote:
> I'm new to Oracle.
> Is there anyway to see which tables in the schema is locked or having
> deadlock?
>
> In MS-SQL Server, under Management > Activity, we can see which
> database and tables is holding the lock and which one is locking.
>
> How about Oracle?
>
> ==============================
> Can I know any tools in Oracle is doing the similar things like
> Profiler in MS-SQL Server?
>
> Thanks.
>
> Peter CCH

Mark's answer is a good one for your question but a bit of advice is in order ... Oracle's locking model is substantially different from that which with you are most familiar. For example in Oracle reads don't block writes, writes don't block reads, and the concepts of page locking (blocks in Oracle) and lock escallation don't exist.

What you are looking for may not have any relevance.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)