oracle 12c database new features for dba

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 in

, rather than on all data. Full-text indexing is tightly integrated into the relational database engine, rather than being provided by another process, as SQL Server 2005 does. New features related to database Administrator (DBA): Dynamic Management Views (DMVs): Multiple

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

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. In the previous article, we summarized the new changes in Think

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 in

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

> 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

When you install an application that contains thousands of tables and indexes, if each table and index is initially allocated a 10 MB initialExtent. You will soon realize that if each object needs to allocate 10 MB of disk space during creation, it will take a lot of time to deploy the DDL. You may thinkOracle delays the initial extent allocation of each object until the actual insert records in the table. The only way to delay the generation of the object's initial segment is to useOracle

New Feature of Oracle 11g R2: Deferred Segment Generation when you install an application that contains thousands of tables and indexes, if each table and index are initially allocated a 10 MB initial extent. You will soon realize that if each object needs to allocate 10 MB of disk space during creation, it will take a lot of time to deploy the DDL. You may think of letting

The following is just the information you get from reading the document, and everything may change before 11GR2 is officially released. 1. RMAN web-services Backup Oracle now allows the database to be backed up directly to Amazon S3 or other cloud storage solutions via Rman, although there is no definitive offer, but it can be expected to be cheaper than buying a library. One of the things that needs to b

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

In 11GR2, Oracle analysis functions are further enhanced. This article introduces the new analysis function Listagg. 11GR2 also adds an analytic function Listagg, the function of which implements string concatenation. In 11GR2, Oracle has finally implemented this analytic function: Sql> select * from V$version; BANNER ---------------------------------------

We have previously introduced the virtual columns and read-only tables in the new Oracle 11g feature. Today we will introduce another new feature, the combined trigger. In earlier versions of Oracle, you can use the FOLLOWS keyword to control the trigger execution sequence. For example: 01 CREATE OR REPLACE

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

Before Oracle 11g, adding a column to a large table and setting the default value would be a tragedy. sometimes you have to select the online redefinition function to achieve this requirement. adding new columns and setting the default values in 11 GB only allows you to modify the data dictionary to achieve this function, greatly improving the efficiency.Add 10g columns (default) SQL> select * from

In 11GR2, Oracle analysis functions are further enhanced. This article introduces the new analysis function Nth_value. Previous versions of the analytic functions, which provided first_value and last_value functionality, and in 11GR2, Oracle added a nth_value feature that includes First_value and Last_value functions, You can also take any number of positive or

". "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

Uncover new features of SQL Server 2014 (1)-memory database, sql2014 Introduction SQL Server 2014 provides many exciting new features, but one of the most anticipated features is the memory da