My Oracle Support Banner

DBA_USERS LAST_LOGIN Field Does Not Populate For SYS User (Doc ID 2445477.1)

Last updated on APRIL 03, 2021

Applies to:

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

Symptoms

 LAST_LOGIN Column in SYS.DBA_USERS view Does Not Get Updated For SYS User Login. It remains blank. 

Changes

 LAST_LOGIN column in SYS.DBA_USERS view is introduced with Oracle Database 12c Release 1 (12.1.0.2) to store the time of the last user login.

 https://docs.oracle.com/database/121/REFRN/GUID-309FCCB2-2E8D-4371-9FC5-7F3B10E2A8C0.htm#REFRN23302

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
Changes
Cause
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.