can anyone point me to the table(s) where I can find which session/task id is blocking others?
"SESSIONID is the value that you can match to other tables like those showing locks." -----Original Message----- From: PcGoober [mailto:[EMAIL PROTECTED] Sent: Thursday, October 07, 2004 7:34 AM To: Kevin Wilson Subject: FW: ending a database session -----Original Message----- From: Dittmar, Daniel [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 06, 2004 10:24 AM To: 'PcgScrapAddy' Subject: RE: ending a database session >how about finding out which task is blocking others (i.e., >locking up the >database with a monster query that has gone haywire)? 'select * from sessions' lets you find the taskid if you know the server and process id of the client. SESSIONID is the value that you can match to other tables like those showing locks. TASKID is the value you need to kill the task using dbmcli ... db_cons Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED]
