12c - Last Successful Login Time in SQL*Plus

No Oracle Database 12c, foi introduzida uma nova funcionalidade no utilitário SQL*Plus, o Last Successful Login Time in SQL*Plus.

O SQL*Plus do Oracle Database 12c adicionou uma informação na tela login, agora por default, é mostrada a última data e hora de login do usuário.

[oracle@oracle01]$ sqlplus scott/tiger
 
SQL*Plus: Release 12.1.0.1.0 Production on Thu Mar 27 16:23:55 2014
 
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
 
Last Successful login time: Wed Mar 26 2014 16:02:23 +01:00
 
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
 

Essa informação também pode ser obtida na view DBA_USERS:

SQL> select username,last_login
from dba_users
where username = 'SCOTT';

USERNAME        LAST_LOGIN
--------------- -------------------------
SCOTT           27.03.2014 16:23:56

Para inibir isso, basta utilizar a opção nologintime:

[oracle@oracle01 tmp]$ sqlplus -nologintime scott/tiger

SQL*Plus: Release 12.1.0.1.0 Production on Thu Mar 27 16:26:40 2014

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options

SQL>

Referências:

 http://docs.oracle.com/cd/E16655_01/server.121/e18404/ch_three.htm

Abraço

Alex Zaballa