User creation details in user$ table - Oracle Database Script.
SELECT NAME,
type#,
ctime,
ptime,
exptime,
ltime
FROM sys.user$
WHERE NAME IN ('SYS',
'SYSTEM')
ORDER BY NAME;
NOTE: CTIME -> USER CREATION TIME PTIME -> LAST PASSWORD CHANGE TIME EXPTIME -> PASSWORD EXPIRY DATE LTIME - > ACCOUNT LOCK TIME