How to monitor Open_cursors within Configurator
(Doc ID 1493070.1)
Last updated on APRIL 04, 2022
Applies to:
Oracle Configurator - Version 12.1.3 and laterInformation in this document applies to any platform.
Goal
Observing problem with open_cursors not getting closed from Configurator sessions of the EBS applications.
Noticed open_cursors of same session for Configurator keep growing with passage of time even after the users
logout of Applications and than logback again on next day.
Following is the trend of Same Configurator sessions increase of open_cursors with passage of time.
Date: 05/29
Config SID - Total Open_curosts
59 - 334
533 - 308
Date: 05/30
Config SID - Total Open_curosts
59 - 493
533 - 468
Date: 05/31
Config SID - Total Open_curosts
59 - 630
533 - 582
Date: 06/01
Config SID - Total Open_curosts
59 - 675
533 - 835
You can see from above every day number of cursors growing for same configurator session id.
Customer is querying v$open_cursor to verify these numbers
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 |
| References |