My Oracle Support Banner

Questions Regarding A New 12c Query (Doc ID 2625264.1)

Last updated on AUGUST 10, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Goal

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?


 

Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.