|
||||
|
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 has made a few changes to the database to allow organizations to reduce the cost of migrating to Oracle 12c. One of these changes is with the size limits that have been placed on the VARCHAR2, NVARCHAR2 and RAW data types. In past versions of Oracle database the maximum size for these data types […] Here you go, http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html I love to see the documentation first. Started downloading Linux version 12.1.0.1 is available for download at edelivery.oracle.com Got this architecture diagram from the internet for 12c database
Source:- Some explanation according to my understanding:- 1) Oracle SGA is shared between multiple databases called Pluggable databases (PDB) 2) A root database called container database which holds all the Oracle dictionary globally (CDB) shareable across PDB’s 3) Listener registers both CDB instance […] Few more collection of new features with in 12c database in continuation to my earlier post in this category RMAN Enhancements:- Recover or copy files from Standby databases Table level restoration i.e object level Incremental recovery more faster, many of the tasks removed RAC Enhancements:- TAF is extended to Transactions failover (insert/update/delete) Dataguard Enhancements:- Global […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!