oracle 12c new features for dba

New Features of Oracle 11g-HM (Hang Manager) In this article, we will introduce the new features of Oracle 11g-hang Manager. We need to note that HM only exists in the RAC database. When we diagnose database problems, we often enc

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 represent the future of

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> Virtual column cannot be lob or raw typeThe

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

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 features of virtual columns, which are described as follows: 1

[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

Before Oracle11.2, you must register the public IP address and virtual IP address of the node to the DNS server to connect the client to the database normally and support Server Load balancer. Dimensions of some clusters Before Oracle 11.2, you must register the public IP and virtual IP of the node to the DNS server to connect the client to the database normally and support load balancing. Dimensions of some clusters Grid plug-and-play (GPnP) Grid

that if the entire server is stolen or even a disk is stolen, these disks can be assembled on servers with the same operating system, and the data will be destroyed. Or there is a DBA with bad conduct. In daily business activities, the DBA maliciously broke through the peripheral protection, and then all your important customer information was ranked out. In either case, if the business involved is in the

because the selectivity is not in the existing cube. Therefore, the system performs a hard analysis and in this case a new child cursor with a second execution plan is generated. In addition, the new optional cube is stored as part of the new child cursor. After the new child cursor is executed, the system stores the

Introduction In. NET applications, there are many ways to achieve access to Oracle databases. However, from functional and performance analysis, Oracle Data Provider for. NET (odp.net) is undoubtedly our best option, a set of interfaces designed by Oracle specifically for. NET applications, which are accessed much faster than other methods. This article will in

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

New Features of Oracle 11g Flashback Data Archive instance, 11 gflashback Flashback Data Archive (flash back log archiving) is actually used to save undo Data for a long time. For some important tables, you can customize the retention period of their historical records, its behaviors are very similar to those of the undo tablespace, and they are completely transp

accessing local sequences• DMLs to local temporary tablesTypical Active Data Guard:• Single-instance physical master database and single-instance physical slave Database• The master database is Oracle Real Application Clusters (Oracle RAC), and the slave database is a single instance.• RAC master database and RAC slave DatabaseFor how to configure Oracle Data Gu

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

Oracle 10g new features-code obfuscation Author: Fuyuncat Source: www.HelloDBA.com Oracle 9i Previously, a command ' warp ' was provided to encrypt the code. But it's command-line, it's script-oriented. In 10g, Oracle Package DBMS_DDL provides a

New Features of Oracle 10 GB-code obfuscation Author: Fuyuncat Source: Www.hellodba.com Before Oracle 9i, a command 'warp' was provided to encrypt the code. However, it is based on scripts in the command line mode. In 10 Gb, the Oracle package dbms_d

". "RO_TEST" DDL statements that affect table data are also restricted. SQL> TRUNCATE TABLE ro_test;Truncate table ro_test*ERROR at line 1:ORA-12081: update operation not allowed on table "TEST". "RO_TEST" SQL> ALTER TABLE ro_test ADD (description VARCHAR2 (50 ));Alter table ro_test ADD (description VARCHAR2 (50 ))*ERROR at line 1:ORA-12081: update operation not allowed on table "TEST". "RO_TEST" A table is a read-only table, but its operations on related indexes are not affected. When the table

> alter session set optimizer_use_invisible_indexes = true;Sql> SELECT * FROM test where object_id = 10;Run a plan----------------------------------------------------------Plan Hash value:255872589-----------------------------------------------------------------------------------------------| Id | Operation | Name | Rows | Bytes | Cost (%CPU) | Time |-----------------------------------------------------------------------------------------------| 0 | SELECT STATEMENT | | 1 | 100 | 2

Introduction Oracle Database 10 Gb provides five new flash back functions: Flash back version query, flash back transaction query, flash back deletion, flash back table and flash back database. Oracle Database 11gR1 provides an interesting new flash back function: Flash back data archiving, which allows an

CompressionColumn compression, a new compression method, consumes more CPU capabilities to achieve lower storage consumption, column compression is transparent to applications, the data warehouse system is worth trying this new function. 5. Data Pump Legacy ModeThe first exp in 11gR2 is no longer supported, and imp is still allowed. Therefore, 11gR2 provides a compatibility mode that allows you to use the