How to monitor Open_cursors within Configurator (Doc ID 1493070.1)

Last updated on JULY 12, 2020

Applies to:

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

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