Skip to content

datageek.ch

Big Data Persistence and Analytics Blog

Month: August 2019

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 triederPosted on 2019-08-02Categories oracleTags oracle services racLeave a comment on Oracle RDBMS – Kill Session by Service

About Me

Thomas Rieder is passionate Data Architect, Oracle DBA, Software Developer and Performance Tuner.He has experience in analyzing and solving quest related large dataset (big data). Contacts LinkedIn Xing

Recent Posts

  • vimium – remap marks key
  • The Perfrect Build Script
  • Add Jenkins Tool Location with ansible
  • docker volume performance (portworx, nfs, bind mount)
  • Oracle RDBMS – Kill Session by Service

Recent Comments

  • Jacek Gebal on PL/SQL Unit Test for SQL geneartor
  • Arie Skliarouk on Vertica installation on Ubuntu 16.04 LTS

Archives

  • December 2021
  • February 2021
  • June 2020
  • May 2020
  • August 2019
  • May 2019
  • September 2018
  • April 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • August 2017
  • May 2017
  • March 2017
  • February 2017
  • December 2016
  • October 2016
  • September 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • September 2015
  • August 2015

Categories

  • docker
  • golang
  • HBase
  • Java
  • Linux
  • oracle
  • Solr
  • Spark
  • Tomcat
  • Uncategorized
  • vertica

Thomas Rieder

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org
datageek.ch Proudly powered by WordPress