To terminate a session, use the Amazon RDS procedure
rdsadmin.rdsadmin_util.kill
. The kill
procedure has
the following parameters.
Parameter name | Data type | Default | Required | Description |
---|---|---|---|---|
|
number |
— |
Yes |
The session identifier. |
|
number |
— |
Yes |
The serial number of the session. |
|
varchar |
null |
No |
Valid values are
If you specify |
To get the session identifier and the session serial number, query the V$SESSION
view. The following example gets all
sessions for the user AWSUSER
.
SELECT SID, SERIAL#, STATUS FROM V$SESSION WHERE USERNAME = 'AWSUSER
';
The following example terminates a session.
BEGIN
rdsadmin.rdsadmin_util.kill(
sid => sid
,
serial => serial_number
,
method => 'IMMEDIATE');
END;
/
The following example terminates the processes associated with a session.
BEGIN
rdsadmin.rdsadmin_util.kill(
sid => sid
,
serial => serial_number
,
method => 'PROCESS');
END;
/