Questions Regarding A New 12c Query
(Doc ID 2625264.1)
Last updated on AUGUST 10, 2020
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Information in this document applies to any platform.
In Oracle 12c the following query executed by several sessions when I query v$session prev_sql_id 9zg9qd9bm4spu:
update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :2) where user#=:1
I had not noticed it in pre 11g versions.
What triggers a session to send that query to the database?
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