如何配置Oracle并发执行? [英] How to configure Oracle execute concurrently ?

问题描述

大家好，

我已经开发了一个应用程序，该应用程序需要一次插入很多数据，并且还需要速度.如果我按顺序插入数据，则运行速度非常慢.因此，我已经创建了一些线程(大约30个线程，请使用ThreadPool)进行插入.但是速度并没有提高.它比我顺序插入时还要慢.怎么解决呢?同时插入时有什么选择吗?

目前，我在Windows 7 64位系统上使用Oracle 10g(10.2.0)，并且已通过基本选项(默认选项)安装了它.我必须更改为Oracle 11g吗?如果需要，我会更改.


-------------------------------------------------- -----------------
当我创建30个Oracle帐户时，它看起来更快.然后，每个线程使用一个帐户连接到Oracle并执行一些插入语句.

Hi everybody,

I''ve developed an application that need to to insert a lot of data at a time and also need speed. If i i insert data sequentially, it run very slow. So, i ''ve create some Thread (about 30 threads, use ThreadPool) for inserting. But the speed is not imporoved. It is even slower than when i insert sequentially. How to solve this? are there any options while installing for concurrently insert?

Currently, I use Oracle 10g (10.2.0) on Windows 7 64bits and i''ve installed it with basic option(default option). Do i have to change to Oracle 11g? If need, i''ll change.


-------------------------------------------------------------------
It''s seem faster when i create 30 Oracle account. Then, each thread uses an account to connect to Oracle and execute some insert statements. Is this a right method??

推荐答案

添加线程对您没有帮助.添加的线程多于内核数，甚至更糟.

更改客户端版本不会使任何事情变得更快.问题出在你的技术上.

在使用Oracle所需的任何容器中设置数据

Adding threads won''t help you. Adding more threads than you have cores is even worse.

Changing the client version won''t make anything faster. The problem is with your technique.

Setup your data in whatever container you need to to use Oracles Bulk Insert[^].

如果您想提高应用程序的性能


您需要使用存储过程与数据库进行交互

不仅如此


在配置文件中进行一些设置


每次您在互联网上托管时，都使用"compilation = false"不进行编译

if u want to improve performance of ur application


u require to use stored procedures to interact with database

not only that


make some settings in configuration file


use ''compilation = false'' to dont make compilation every time when u hosted on internet

这篇关于如何配置Oracle并发执行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！