My Oracle Support Banner

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

Last updated on NOVEMBER 02, 2021

Applies to:

Oracle Forms - Version 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.

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.


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?


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.