When upgrading to Oracle 12c it’s good to be familiar with the deprecated parameters. These are not really desupported, just that they will be de-supported in future versions of the Database. Read more ..
Large enterprise database environments have dedicated DBAs performing specific database roles. Some of these specific roles include database storage management, tuning, backup and recovery, etc. Inside these organizations there has been growing concern to further ensure the use of the SOD (Segregation of Duties) concept, to fulfill duties for these roles.
In Oracle Database 12c there are two new features which can be used to control the validity and visibility of the data. They are called Temporal Validity and In Database Archiving. The concepts behind these two new features are a bit interlinked, so it is important to understand and distinguish between these two. In this […]
Starting from 12c you can now use Unified auditing to keep track of all audit data in a single audit trail.
The In-Database Archiving in Oracle 12c Database, llows you to mark certain rows inside the table as inactive or archived. The rows marked as archived will stay in table but they will be unavailable to users and applications.