Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11gr2 new APPEND_VALUES tips     - Examples of safety testing system notes for RedHat Linux (Linux)

- Phoenix agents use P2P WebRTC development (Programming)

- Docker Build a Java compiler environment (Linux)

- To setup the Swift language learning environment under linux (Linux)

- SLF4J Tutorial (Programming)

- Oracle archive log full cause abnormal slow database performance (Database)

- 20 Top Linux commands (Linux)

- Linux /var/spool/ insufficient clientmqueue space solutions (Linux)

- Reported too many open files Linux solutions (Server)

- error no.2013 lost connection Tom with SQLServer during query (Database)

- Three strategies to teach you to release the device memory (Linux)

- Installation Elementary OS Freya to do some settings (Linux)

- Ubuntu 15.10 15.04 14.10 14.04 Install Ubuntu Tweak (Linux)

- Go Languages Reviews (Programming)

- Linux 0.12 kernel and modern kernels difference in memory management (Linux)

- Shared directory settings between Linux and Linux (Linux)

- MongoDB simple replication configuration (Database)

- Prevent security threats caused Rootkit (Linux)

- Kali Linux virtualbox rc = Error 1908 workaround (Linux)

- Teach you to diagnose problems with strace (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:      
 
- How to install Bugzilla 4.4 on Ubuntu / CentOS 6.x (Linux)
- The difference between statement and preparedStatement of the jdbc (Database)
- Under Linux using Magent + Memcached cache server cluster deployment (Server)
- Close common port to protect server security (Linux)
- Java string intern constant pool resolution Introduction (Programming)
- PPA on Ubuntu Linux installation Plank 0.8.0 (Linux)
- Red Hat Enterprise Linux 6.4 Configuring VNC Remote Desktop login access (Linux)
- How x2g0 install Remote Desktop on Linux VPS (Server)
- RedHat Linux 9.0 under P4VP-MX motherboard graphics resolution of problems (Linux)
- Getting case of Python Hello World (Programming)
- Java, on the dfile.encoding Systemproperty (Programming)
- Detailed software to run UnixBench (Linux)
- Linux mount command Detailed (Linux)
- Stunning exclamation point at the Linux command line (Linux)
- Nodejs complete installation instructions for Express (Linux)
- Ubuntu installation 2.10.x version of Scala (Linux)
- Linux environment installation of rvm and ruby (Linux)
- Android 5.1 OTA package compilation error (Programming)
- Attic-- delete duplicate data backup program (Linux)
- SUSE Linux network configuration and firewall configuration (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.