PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Change dbflags parameter from 0 to 8?

edited Jun 20, 2018 12:21PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 13 commentsAnswered ✓
Does anyone know of any potential issues changing the dbflags value from 0 to 8. We are on tools 8.50.24 and Oracle 11g. This change appears to fix an issue we have with cusors being held open by the master scheduler. Once we get to around 1000 cursors open, the next job that is scheduled to run gets stuck queued. By changing this value to 8, we never get close to 1000 cursors open.

; DbFlags Bitfield
;
; Bit       Flag
; ---       ----
; 1         - Ignore metaSQL to update database statistics(shared with COBOL)
; 2         - not yet allocated
; 4         - Disable Second DB Connection
; 8         - Disable Persistent Secondary DB Connection
; 16        - not yet allocated

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center