How To Get The Process Id Of The Orphaned / Runaway Processes
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
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.
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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms