Abort (kill) specific session on a server

Snowflake provides function to terminate specific session on a server.

Find session ID

First we will identify the session we want to end.

User Interface

We can make it by listing all sessions on the server in the Web User Interface:

sample results

Show Locks

If our transcation has lock on resources we can get session id from query below:

show locks in account;

Kill session

Now we will use session ID to abort the session (6137508847650 in our example):

select SYSTEM$ABORT_SESSION( 6137508847650 );

Result

sample results

0
There are no comments. Click here to write the first comment.