oracle 12c database new features for dba

one. Adaptive cursor Sharing (adaptive Cursor sharing) Description 1.1 ACS Overview Binding variables Enable Oracle DB to share a single cursor for multiple SQL statements to reduce the amount of shared memory used for parsing SQL statements. However, cursor sharing and SQL optimization are two conflicting goals. Writing SQL statements in writing provides more information to the optimizer, which will undoubtedly lead to better execution plans, but a l

About Oracle 10 Gb performance, the most talked about is the new automatic workload repository (AWR) features and proactive performance monitoring through automatic database Diagnostic Monitoring (ADDM. They are widely reported as an alternative to STATPACK. Indeed, according to Mr. Niemiec, they can do more to represe

DB version: Oracle database 11g Enterprise Edition release 11.2.0.2.0- 64bitORACLE11G adds new features for virtual columns, as described below:1> can only create virtual columns on the heap organization table (normal table), cannot create virtual columns on index organization tables, external tables, temporary tables2

ThinkPHP3.2.3 new features of database settings, thinkphp3.2.3. ThinkPHP3.2.3 new features of database settings, thinkphp3.2.3ThinkPHP3.2.3 version of the database driver using PDO comp

New Features of Oracle 11g (1)-virtual column, oracle11g Database Version: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0-64bit The Oracle11g introduces new

New Features of Oracle 11g virtual column partitioning There is a need: a document table should be partitioned by month. If it is on Oracle 10 Gb, only one field can be added. It will be different after the Oracle 11g. You can use virtual column processing. SQL> select * fro

[Translated from mos] New Features of Oracle 11gR2 relink, 11gr2relink New Features of Oracle 11gR2 relink Source:Oracle 11gR2 Relink New Feature (Document ID 883299.1) Applicable:Oracl

1. DB_BLOCK_CHECKSUM parameter description Before Oracle 10.2.0.3: DB_BLOCK_CHECKSUM has two options: TRUE and FALSE. The default value is TRUE. In Oracle 10.2.0.3: DB_BLOCK_CHECKSUM has three options: OFF | TYPICAL | FULL. The default value is TYPICAL. In Oracle 11g: DB_BLOCK_CHECKSUM has five options: OFF | FALSE | TYPICAL | TRUE | FULL, the default value is TY

Before 11g, add a field with default value, the implementation principle is as follows:ALTER TABLE T1 add C1 varchar2 (a) default ' XX ' NOT null;Assuming that the T1 table has 40 million rows of data, Oracle returns a "Success Prompt" to the user when it executes the above DDL statement while updating the 40 million rows of data successfully. The following issues may be caused:1. Updating 40 million rows of data takes a long time to complete.2. Exhau

In the previous article, we summarized the new changes in ThinkPHP3.2. in this article, we will take a detailed look at the new features of the database, which are very detailed. if you need them, refer to them. The database driver of ThinkPHP3.2.3 is completely rewritten us

In the previous article, we have summed up the new changes in the next ThinkPHP3.2, this article we will look at the database on what the new features, very meticulous, the need for small partners under the reference. --> The ThinkPHP3.2.3 version database driver is fully r

As Oracle confirms the remaining 4 Java 9 features, the next generation of Java plans is beginning to become clearer, and Oracle has unveiled the second set of Java 9 features. Since Oracle announced 3 new APIs and modular sources

1. Flashback drop Currently, Oracle10g provides the new flashback drop feature to accelerate the recovery of user error operations. The flashback drop function allows you to restore a dropped object from the current database. When you perform the drop operation, Oracle does not delete the object but automatically puts the object into the recycle bin. The recy