Re: Any way to know database lock?

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 11 Mar 2005 01:51:04 -0800
Message-ID: <1110534664.638154.125460@o13g2000cwo.googlegroups.com>

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?
>

You can run queries and get any information from the Oracle database i.e. if you are familiar with Oracle's data dictionary. But witnessing the point-and-click culture that prevails in M$, Oracle does provide bunch of tools in the new releases i.e. 9i and above.

For your purpose, if you have installed OEM (Oracle Enterprise Manager) then you can launch "Performance Manager" that is available from start menu in standalone and get to this information.

Regards
/Rauf Received on Fri Mar 11 2005 - 03:51:04 CST