Query On V$SESSION_FIX_CONTROL With IN Condition Returns Value Not Only for The Current Session
(Doc ID 3060828.1)
Last updated on DECEMBER 07, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterInformation in this document applies to any platform.
Symptoms
According to online documentation,
V$SESSION_FIX_CONTROL displays information about Fix Control (enabled/disabled) for the current session.
But when querying V$SESSION_FIX_CONTROL with IN condition, sometimes it returns values for session(s) other than the current as well.
Example:
Cause
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
Symptoms |
Cause |
Solution |