This table describes how to view and terminate Oracle process threads:
View Oracle process threads and terminate the threads within each process.