Any way to know database lock?

From: Peter CCH <petercch.wodoy_at_gmail.com>
Date: 10 Mar 2005 23:13:54 -0800
Message-ID: <1110525233.966316.80930@z14g2000cwz.googlegroups.com>

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 Received on Fri Mar 11 2005 - 01:13:54 CST