oracle 12c new features

Read about oracle 12c new features, The latest news, videos, and discussion topics about oracle 12c new features from alibabacloud.com

Summary of the new features of Oracle 12c on business impact (1)

Summary of the new features of Oracle 12c on business impact (1) 1. invisible fields In Oracle 11g R1, Oracle introduces some good enhancement features in the form of invisible indexes

New Oracle 12C features online renaming, migrating active data files

-----. 1 Oracle Oinstall 272637952 may 04:30 system01.dbf-rw-r-----. 1 Oracle Oinstall 67117056 may 07:02 temp01.dbf-rw-r-----. 1 Oracle Oinstall 104865792 may 04:30 undotbs01.dbf-rw-r-----. 1 Oracle Oinstall 14426112 may 04:10 users01.dbf-rw-r-----. 1 Oracle Oinstall 525107

Oracle 12c new features (for DBA)

One: Multitenant Architecture (12.1.0.1)Multi-tenant architecture is the new heavyweight feature of Oracle 12c (12.1), built-in multi-tenancy (multi-tenancy), a container database (container) that can hold multiple pluggable Databases, Each pluggable database is independent of the other pluggable database.For external applications and developers, pluggable databa

Summary of new features in Oracle 12C SQL

Summary of new features in Oracle 12C SQL Multiple indexes on the same field Before Oracle 12c R1, a field cannot have multiple indexes in any form. Some may wonder why a field usually requires multiple indexes. In fact, there are

Oracle Database 12c New features Summary (i)

Tags: des style blog http color io os using ARThis series of articles is a summary of some of the new features of Oracle database 12c, including database management, RMAN, high availability, and performance tuning, Syed Jaffer Hussain.1. Online renaming and repositioning of active data filesUnlike previous versions, th

Extended data type for Oracle 12C new features (extended

Oracle 12C new Features-extended data type, in 12c, the size of data types such as VARCHAR2, NAVARCHAR2, and raw are extended from 4K and 2K bytes to 32K bytes, compared to earlier versions. As long as possible, the size of the extended character decreases the use of the LOB

Add columns with default values in Oracle tables (including new 12C features) and oracle12c

Add columns with default values in Oracle tables (including new 12C features) and oracle12c This is a problem that I have been paying attention. 11G has been improved on this issue, and 12C has some new

Adding columns with default values to tables in Oracle (including new 12C features)

Adding columns with default values to tables in Oracle (including new 12C features) This is a problem that I have been paying attention. 11G has been improved on this issue, and 12C has some new

New Features of Oracle DB 12c: raw device bare devices are no longer supported, oracle12c

New Features of Oracle DB 12c: raw device bare devices are no longer supported, oracle12c New Feature of Oracle DB 12c: raw device is no longer supported. Reference:Announcement of De-S

Oracle 12C new Features-pluggable database feature

--------------------------------------------------------------------------------/oracle/app/oradata/cup/datafile/o1_mf_system_bch07kvz_.dbf/oracle/app/oradata/cup/datafile/o1_mf_sysaux_bch020oo_.dbf/oracle/app/oradata/cup/datafile/o1_mf_undotbs1_bch0d2on_.dbf/oracle/app/oradata/cup/datafile/o1_mf_users_bch0d15n_.dbfTo

New Features of Oracle 12C-online migration of table partitions or subpartitions

New Features of Oracle 12C-online migration of table partitions or subpartitions Oracle 12c: new feature-online migration of table partitions or subpartitions. It is no longer necessar

In-database archiving of Oracle 12c new features (In-database archiving)

The new features of In-database archiving are introduced in Oracle Database 12c, which allows users to archive data by marking data rows on the table as inactive inactive. These inactive data rows can be compressed into one optimization and are not visible to the app by default. This feature enables the functionality a

Oracle 12C r2-new features-pdb disk I/O (iops,mbps) resource management

Oracle 12C r2-new features-pdb disk I/O (iops,mbps) resource managementIn previous versions, there was no easy way to control the amount of disk I/O used by a single PDB. As a result, a PDB may run out of disk I/O and affect the performance of other PDB in the same instance. The Or

Oracle 12C new features table partition with asynchronous Global index asynchronous maintenance (once add, truncate, drop, spilt, merge multiple partitions)

------------------------- ------------------------- ------------------ ------------------------------ -------------P_andy P1 1 USERS 10P_andy P2 2 USERS 20P_andy P3 3 USERS 30P_andy P5 4 USERS 33P_andy P6 5 USERS 36P_andy P4 6 USERS 40Iv. merging multiple partitions into one partition--Table partitioning situationSql>Select Table_name,partition_name,partition_position,tablespace_name,high_value from user_tab_partitions where table _name= ' P_andy ';table_name Partition_name partition_position Ta

Invisible fields for new features of Oracle 12c

; INSERT INTO invisible_t (ID,NAME,PASSWD) VALUES (1, ' Andy ', 1);1 row created.sql> INSERT INTO invisible_t (Id,name) VALUES (2, ' andy02 ');1 row created.3. Query statusSql> select * from invisible_t;ID NAME---------- --------------------1 Andy2 andy02Sql> select Id,name from invisible_t;ID NAME---------- --------------------1 Andy2 andy02Sql> select id,name,passwd from invisible_t;ID NAME PASSWD---------- -------------------- --------------------1 Andy 12 andy024. Modify field to visible or

Oracle 12C new features DB default character set Al32utf8, PDB supports different character sets

One, DB default character set Al32utf8Specify the database character set when you create the database. Starting from Oracle Database 12c Release 2, if you use Oracle Universal Installer (OUI) or Oracle database Configuration Assistant (DBCA) to create a database and then the default database character set used is the U

Table in Oracle adds a discussion with a default value column (including 12C new features)

has been strengthened again, we can not set the NOT NULL here, greatly reducing the possible error operationSee the following experimental processCREATE table T, where more than 1 million rows of data.Sql> Select COUNT (*) from T; COUNT (*)---------- 1454256Add a column directly to the table (not set NOT NULL)Sql> ALTER TABLE t add MRDAI1 number default 10000; Table altered. elapsed:00:00:00.03The speed is swift. And, of course, as in 11G.After the setting is complete, if it is a newly inser

New features of Oracle 12C move (non-partitioned tables) Table online

;Table altered.--View index statusSql>Col index_name for A25Select Table_name,index_name,status,blevel,leaf_blocks,orphaned_entries from user_indexes where index_name = ' IDX_ Andy_id ';table_name index_name STATUS blevel leaf_blocks ORP------------------------- ------------------------- -------- ---------- ----------- ---Andy_move idx_andy_id VALID 0 0 NO--Move online partition table errorSql> ALTER TABLE P_andy move online;ALTER TABLE P_andy move online*ERROR at line 1:Ora-14808:table does not

Oracle 12C new features Sqlplus view the history command

reserved Records is 100Sql>set History 3;7. View Hist retained RecordsSql> hist list;1 show Con_name2 show parameter version;3 Show hist;Description: The number of records retained is calculated by command rather than by line count.8. Run the specified recordSql> hist;1 Select sysdate from dual;2 show Con_name3 Select date from dual;Sql> hist 2 run;Con_name------------------------------Cdb$root9. Edit the previous commandhist 1 edit;Description: You can operate like Linux VI and edit the retain

Prepare to Upgrade ORACLE to learn new 12C features

explicitly inserted; METADATA-ONLY default value refers to the default value specified when a new column is added, and the difference in 11g is that, the default value of 11g must be not null. 3. extend the length limit of multiple data types: Increase the VARCHAR2, NVARCHAR2, and RAW types to 32 K, set compatibility to 12.0.0.0 or above, and set the initialization parameter MAX_ SQL _STRING_SIZE to EXTENDED, this function does not support CLUSTER ta

Total Pages: 15 1 2 3 4 5 .... 15 Go to: Go

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.