Sunday , June 16 2024

How To Find Process Informations of a Session(Kill Oracle Session)

You can access the process information of a session in the Oracle database with the following query. Sometimes it is not possible to terminate a session with ‘kill session’. In this case, it is necessary to kill the process of the session via the operating system. With the following query, you can find out instance (inst_id) and process id (spid) information of the process.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

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