Re: Insert Into ... Select, Delte Data
You´re right Rick, the real table have more than 150 million rows. Also there run more than one java application. Each application store more than 100 (sometimes more than 500) rows every secound.
At the moment all applications writing each new row directly into the real table (a).
The aim of the new behavoir is to minimize the write traffic in the real table (a) because "Table_locks_waited" is overmuch and this slows down the application. Now each application shall creat an own table b during runtime, in there the application "batch" its entrys and write them into the real table when table b size is over XXXX.
Thank you, creating a secound temporary table sounds well! I already tought about it but would ask if anyone knows a query what operates like "cut" in the file system.
Subject
Written By
Posted
September 06, 2014 02:24PM
September 06, 2014 03:57PM
September 06, 2014 08:26PM
Re: Insert Into ... Select, Delte Data
September 07, 2014 04:07AM
September 07, 2014 11:57AM
September 09, 2014 07:09AM
September 09, 2014 11:31AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.