A other new feature in 12c is the possibility to restore a table with rman. In a pre 12c for example you will do a Tablespace Point In Time Recovery (TPITR) to create a auxiliary database and then export your table from there. In 12c the steps are the same, but you will need a…
A small but nice new feature in the 12c database is, that the last login time of a user is recorded into the USER$ table. Therefore only a simple SQL is needed on the dba_users view to get this information. SQL> select username,last_login from dba_users where last_login is not null; USERNAME LAST_LOGIN ——————-…
Pre 12c Database there was no hard limit for the PGA (except the OS ressources). The fact that the Program Global Area has no hard limit can lead to unstable system (if the system begins to page out). In a worst case a Real Application Cluster can make a node eviction. 12c Oracle has introduced…
Peter`s DBA Blog 