Anasayfa / Database / informix / Informix lock user sesion list

Informix lock user sesion list

SELECT s.username tutan_kullanici,
 s.sid tutan_session,
 t.username bekleyen_kullanici,
 t.sid bekleyen_session,
 l.type locktype,
 l.dbsname veritabani,
 l.tabname tablo,
 l.rowidlk tutulan_rowid
FROM sysmaster:syslocks l
 INNER JOIN sysmaster:syssessions s ON s.sid = l.owner
 LEFT JOIN sysmaster:syssessions t ON l.waiter = t.sid
WHERE l.dbsname <> 'sysmaster'
 and l.tabname <> 'sysdatabases'
ORDER BY veritabani,
 l.tabname;

 

Hakkında ibrahim

İlgili Makaleler

python informix char to nchar varchar to nvarchar replace

import re import sys import getopt import os exclude_rows = ['informix.syserrors', 'informix.systracemsgs', 'informix.systraceclasses', 'grant dba …

Bir cevap yazın

E-posta hesabınız yayımlanmayacak.