Biju

The SYS.USER$ table in Oracle Database 12c includes a column to store the last login time of the user. In the previous releases, to be able to know the last login time of the user, we had to enable “AUDIT SESSION” and then query the AUD$ table. As part of the increased security features in … Read more

Datapump Import impdp in 12c includes a new parameter to disable logging during data import. This option could improve performance of import tremendously during large data loads. The TRANSFORM=DISABLE_ARCHIVE_LOGGING is  used to disable logging. The value can be Y or N. Y to disable logging and N to enable logging. The second attribute specifies whether … Read more