Rauf Sarwar wrote:
> 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
>
you dont even need to launch perf man if you are in OEM console, just
expand "instance" in the DB tree and it will show you any active locks
from there.
Received on Wed Mar 16 2005 - 12:21:50 CST
