Oracle Database

Oracle Database, the related services (cloud) and various options in the database.

OracleDB12c New Feature: Rename and Replace ASM Disk(s) in Diskgroup

by

As I have not set up 12c GI ASM yet, have not tested this feature… Rename clause is nice to have. Replace clause helps to avoid multiple steps when replacing disk (LUN) with new one [array migration, for example]. Information below is straight copy from Oracle Documentation… rename_disk_clause ALTER DISKGROUP diskgroup_name RENAME { DISK old_disk_name … Read more

OracleDB12c New Feature: Last Login Time of User

by

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