How to monitor Open_cursors within Configurator (Doc ID 1493070.1)

Last updated on JULY 14, 2016

Applies to:

Oracle Configurator - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 26-FEB-2014***

Goal

Customer is observing problem with open_cursors not getting closed from Configurator sessions of the EBS applications.
They have 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/2012
Config SID - Total Open_curosts
59 - 334
533 - 308

Date: 05/30/2012
Config SID - Total Open_curosts
59 - 493
533 - 468

Date: 05/31/2012
Config SID - Total Open_curosts
59 - 630
533 - 582

Date: 06/01/2012
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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms