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.