|
||||
|
By default, some background processes on UNIX and Linux always use threaded execution; the remaining Oracle processes run as operating system processes. Thus, an “Oracle process” is not always equivalent to an “operating system process.” Parameter THREADED_EXECUTION specifies whether to enable the multithreaded Oracle model. Starting in Oracle Database 12c, the multithreaded Oracle model enables […] Yes for for Temporary Tables. Here is the excerpt from the documentation:- By default, undo records for temporary tables are stored in the undo tablespace and are logged in the redo, which is the same way undo is managed for persistent tables. However, you can use the TEMP_UNDO_ENABLED initialization parameter to separate undo for temporary […] An direct example from documentation with clear explanation In-Database Archiving enables you to archive rows within a table by marking them as inactive. These inactive rows are in the database and can be optimized using compression, but are not visible to an application. The data in these rows is available for compliance purposes if needed […] In 12c you can enable DDL logging, before to that there was no way to know who has done the DDL on that object unless auditing enabled. The ENABLE_DDL_LOGGING initiation parameter must be configured in order to turn on this feature. The parameter can be set at the database or session levels. […] Privilege capture is a feature to track the privileges that is used for a user, This is very useful in auditing and show results of privileges has used during the capture period. In 12c the Separate user duties are as below SQL> select username from dba_users where username like ‘%SYS%’; USERNAME ———————————- SYS : Super […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!