Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11gr2 new APPEND_VALUES tips     - Fedora network set up simple (Linux)

- Use rfkill soft-switching and Bluetooth wireless capabilities in Linux (Linux)

- PostgreSQL Source Customization: Online global read only (Database)

- Linux (RHEL5) general optimization system security (Linux)

- C ++ Supplements - Smart Pointers (Programming)

- Linux find and xargs (Linux)

- GitHub multiplayer co-development configuration (Linux)

- RPM package fabrication method (Linux)

- The correct way of logical backup mysqldump (Database)

- Detailed Linux su command to switch users Mistakes (Linux)

- Protect against network attacks using Linux system firewall (Linux)

- Proficient in C / C ++ can also find a very good job (Programming)

- Redis 3.0.3 Cluster Setup (Database)

- Ubuntu install Wireshark (Linux)

- High-performance Linux system firewall detailed analysis of double-effect (Linux)

- Generate two-dimensional code parsing code Java (Programming)

- CentOS install video converter FFmpeg and cutting tools segmenter (Linux)

- RedHat6.4 installation tutorial --- Minimal Edition (Linux)

- Timing Nginx logs cut and remove the log records of the specified number of days before (Server)

- Linux AS4 VPN server in conjunction with a firewall perfect (Linux)

 
         
  Oracle 11gr2 new APPEND_VALUES tips
     
  Add Date : 2017-08-31      
         
       
         
  In 11.2, Oracle added APPEND_VALUES tips, making INSERT INTO VALUES statement can use the direct path insert.

Example is very simple:
SQL> SELECT * FROM V $ VERSION;

BANNER
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL / SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
SQL> CREATE TABLE T_APPEND (ID NUMBER, NAME VARCHAR (30));
Table has been created.
SQL> INSERT / + APPEND (A) / INTO T_APPEND A
2 VALUES (1, 'ABC');
It has created a row.
SQL> SELECT * FROM T_APPEND;
ID NAME


-------------------------------------------------- ------------------------------

    1 ABC
SQL> COMMIT;
Submit completed.
SQL> INSERT / + APPEND (A) / INTO T_APPEND A
2 SELECT ROWNUM + 1, TNAME
3 FROM TAB
4 WHERE ROWNUM = 1;
It has created a row.
SQL> SELECT * FROM T_APPEND;
SELECT * FROM T_APPEND
*
Line 1 Error:
ORA-12838: Unable to modify in parallel mode after the read / modify objects

SQL> COMMIT;
Submit completed.
Results comparing INSERT INTO VALUES and INSERT INTO SELECT statement is you can clearly see, APPEND prompted for INSERT INTO VALUES statement is invalid, the data is still using conventional path insert.
Use APPEND_VALUES tips 11.2, which makes a single insert statement truly direct path mode:
SQL> INSERT / + APPEND_VALUES (A) / INTO T_APPEND A
2 VALUES (3, 'APPEND_VALUE');
It has created a row.
SQL> SELECT * FROM T_APPEND;
SELECT * FROM T_APPEND
*
Line 1 Error:
ORA-12838: Unable to modify in parallel mode after the read / modify objects

SQL> COMMIT;
Submit completed.
SQL> SELECT * FROM T_APPEND;
ID NAME
     
         
       
         
  More:      
 
- Oracle ORA-01089 failure analysis (Database)
- Chkconfig set boot start under Linux (Linux)
- Basic Java JNI (Programming)
- Cobbler Add custom YUM source (Linux)
- Why learn and use C language (Programming)
- C # compiler to achieve functional use in the runtime (Programming)
- DOM event handlers add notes (Programming)
- Broadcom transplanted to OpenWrt summary (Programming)
- awk pattern matching (Programming)
- IP configuration under Linux (Linux)
- Using shell users or virtual users to login to pureftpd (Linux)
- Kibana Apache Password Authentication (Server)
- Linux installation JDK1.6 rpm.bin assembly (Linux)
- Character Encoding notes: ASCII, Unicode and UTF-8 (Linux)
- Merge sort Java implementation (Programming)
- Linux environment to build next Cocos2dx-3.3.1 (Linux)
- Tmux Getting Start (Linux)
- Linux platform Oracle MySQL connection (Database)
- Install the system cleaning software under Linux: BleachBit 1.4 (Linux)
- Getting Started with Java NIO (Programming)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.