How to kill an Oracle database session

Procedure:(1)Determine the process ID (PID) of the operating system process which corresponds to the database session.

Examples:

(1.1)You suspect that a database session is spinning and consuming a significant amount of CPU time.In this case the UNIX command top may report the corresponding operating system process as one of the top consumers of CPU time and provide its PID.

(1.2)You know the parent process which initiated the database session you want to kill, e.g. a script that called SQL*Plus which in turn opened the database session.In this case the parent process has an sqlplus process as its child, and that sqlplus process has a database server process as its child: