Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11gr2 new APPEND_VALUES tips     - Installation and Configuration rsync server under CentOS 6.3 (Server)

- 20+ Best Practices article MySQL Performance Optimization (Database)

- AngularJS - Custom instructions (Programming)

- CentOS yum source configuration (Linux)

- The difference between statement and preparedStatement of the jdbc (Database)

- Use JMS listener Oracle AQ, trigger the execution of Java programs in the database changes (Database)

- CentOS and RHEL to install IPython 0.11 (Linux)

- Kibana use installation (Linux)

- Use CutyCapt to convert HTML pages to png images on Linux (Linux)

- Implement firewall function on a closed Linux machine (Linux)

- Linux Troubleshooting: How to save the status of the SSH session is closed (Linux)

- Android design patterns - state mode (Programming)

- Win8 mount disk partitions under Ubuntu (Linux)

- The virtual memory (Linux)

- Linux server security - the web server configuration (Linux)

- Android use canvas board painting (Programming)

- Java memory area Explanation (Programming)

- Linux bash: scp: command not found the problem (Linux)

- To setup NOTRACK and TRACK of conntrack in iptables (Linux)

- How to install Ubuntu applications Device 7 (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:      
 
- Use DB2 federated access Oracle (Database)
- CentOS6.0 successful installation and configuration OpenCV (Linux)
- Use calcurse schedule appointments and to-do in the Linux terminal (Linux)
- Linux processes in memory and memory cgroup statistics (Linux)
- Configuring DNS process under CentOS 6.5 (Server)
- Java data structures - the single linked list LinkedList linear table (Programming)
- C ++ based socket communication TCP and UDP (Programming)
- Steps to build MPICH2 development environment on CentOS 6.4 (Linux)
- Analysis of memory mapping process in Linux x86-64 mode (Linux)
- Shell Scripting Interview Questions (Programming)
- Build a Linux development environment under STC89C52RC (Linux)
- Spring AOP custom annotation way to achieve log management (Programming)
- Ubuntu install Eclipse for C / C ++ and related configuration (Linux)
- Kafka + Log4j log implement centralized management (Server)
- Docker in the development and practice of IFTTT (Server)
- By way of a binary installation innobackupex (Database)
- Docker commonly used commands Description (Linux)
- Kubernetes resolve application deployment model (Server)
- Linux installation beautify early experience (Linux)
- Shilpa Nair interview experience sharing RedHat Linux package management (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.