How To Get The Process Id Of The Orphaned / Runaway Processes
(Doc ID 1462144.1)
Last updated on MAY 04, 2023
Applies to:
Oracle Forms - Version 10.1.2.0.2 and laterOracle Forms for OCI - Version 12.2.1.3.0 and later
Information in this document applies to any platform.
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
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
| Goal |
| Solution |