How To Get The Process Id Of The Orphaned / Runaway Processes (Doc ID 1462144.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Forms - Version 10.1.2.0.2 and later
Information in this document applies to any platform.
Checked for relevance on 05-Nov-2013
Checked for relevance on 21-Apr-2015

Access Privileges:

Requires SELECT privilege on v$process and v$session or SELECT_CATALOG_ROLE(Oracle8
and higher). See the References section for a potential problem granting the necessary privileges.

Usage:
sqlplus username/password@connectstring

Caution :
-----------
This script is provided for educational purposes only and not supported by Oracle Support Services. It has been tested internally, however, and works as documented. We do not guarantee that it will work for you, so be sure to test it in your environment before relying on it.

Proofread this script before using it! Due to the differences in the way text editors, e-mail packages and operating systems handle text formatting (spaces, tabs and carriage returns), this script may not be in an executable state when you first receive it. Check over the script to ensure that errors of this type are corrected.
Script

Goal

A user session on the Oracle database has probably lost connection to the server process managed by the middleware environment and has been orphaned. The frmweb.exe process has become a runaway process and is consuming more memory on the midleware server.

How to get the process id of the orphaned processes to kill those sessions?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms