Numbers of Locks
Hi all, How to find out how many locks is hold by particular users / process ? Thanks and Regards, Tham
Tham Huei Hwan wrote in message <96a5b7$h0c$1@news.xmission.com>...
>
>How to find out how many locks is hold by particular users / process ?
>
onstat -u has a column for number of locks, but it's a summary of thedifferent types.
onstat -k gives you more detail.
You have to "join" the address column from the onstat -u with the owner
column of the onstat -k to correlate the two facts together.
There are also sysmaster tables with this information in.
syslocks
syssesprof
syssessions
sysseswts
in the Administrators guide to the engine.
if you are on unix
you can issue the following command
onstat -k |awk '{print $3}'|sort|uniq -c|sort -nr|morethis will give the threads with the # of locks that each of them hold
the onstat -u |grep <thread id> will give you the sid
Nati
On Tue, 13 Feb 2001 09:56:42 +0800, Tham Huei Hwan
<hhtham@apis.dhl.com> wrote:
>
>Hi all,
>
>How to find out how many locks is hold by particular users / process ?
>
>Thanks and Regards,
>Tham