Oracle Database 11.2.0.4
Hi,
how do I find last time users logged in and those who did not login for past 180 days
USERNAME PROFILE ACCOUNT_STATUS
--------------------------------------------- ------------------------------ ------------------------------
SYS DEFAULT OPEN
SYSTEM DEFAULT OPEN
OUTLN DEFAULT EXPIRED & LOCKED
DIP DEFAULT EXPIRED & LOCKED
MUZAMMER DEFAULT OPEN
DBSNMP DEFAULT OPEN
APPQOSSYS DEFAULT EXPIRED & LOCKED
WMSYS DEFAULT EXPIRED & LOCKED
XS$NULL DEFAULT EXPIRED & LOCKED
EXFSYS DEFAULT EXPIRED & LOCKED
XDB DEFAULT EXPIRED & LOCKED
USERNAME PROFILE ACCOUNT_STATUS
--------------------------------------------- ------------------------------ ------------------------------
ANONYMOUS DEFAULT LOCKED
ORDSYS DEFAULT EXPIRED & LOCKED
ORDDATA DEFAULT EXPIRED & LOCKED
ORDPLUGINS DEFAULT EXPIRED & LOCKED
SI_INFORMTN_SCHEMA DEFAULT EXPIRED & LOCKED
MDSYS NICE_PROFILE OPEN
MDDATA DEFAULT EXPIRED & LOCKED
SPATIAL_WFS_ADMIN_USR DEFAULT EXPIRED & LOCKED
PP2 DEFAULT OPEN
SPATIAL_CSW_ADMIN_USR DEFAULT EXPIRED & LOCKED
DBADM NICE_PROFILE OPEN
Regards,
Roshan