My Oracle Support Banner

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 later
Information in this document applies to any platform.


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


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.