Oracle RDBMS – Kill Session by Service

A way to remove session by a partitcular services is to stop the service:

srvctl stop service -db <dbname> -service <service_name>

And den kill all Session to this service:

sql> exec dbms_service.KILL_SESSION(‘<service_name>’,1);

This functions seems not to be documented (in the 18c docs).

Author: trieder

Born with CPP, rased with SQL, living with NVIM

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.