OracleDB12c New Feature: SQL*Plus NOLOGINTIME Option

Oracle Database 12c has added a lot of features to the database and supporting tools. SQL*Plus is no exception. The login or invoking of SQL*Plus includes more command line options.

As in the previous releases, the -H command line option shows the help information.

By default SQL*Plus displays the last successful login time, similar to most Unix distributions. The -NOLOGINTIME option turns it off.

When using the CONNECT syntax after login to SQL*Plus, the last login time is not displayed.

The security features of 12c database is very much enhanced, hence the database tracks the last login time of each user. This information is displayed during the SQL*Plus login to the database.

You do not have to mess with the AUDIT_TRAIL anymore to find the last login time, last login tracking is captured by default.

 

One Reply to “OracleDB12c New Feature: SQL*Plus NOLOGINTIME Option”

Comments are closed.