Re: Large XML Data, Parsing, JDBC, RMI, 2 Oracle DB

I guess I have to split the file into smaller file, then make the Parse to work concurently.

In article <tlilner8k3pd5d_at_corp.supernews.com>, "Raden Java" <radenjava_at_theglobe.com.invalide> wrote:

> Hi,
>
> I'm trying to insert a large of data over 25,000,000 elements in xml
> format to 2 different Oracle Database on 2 different server.
>
> I'm currently working on 4 machines, machine A 1 and 2 is a database
> running Oracle 9i, machine B is a parsing machine (8 CPU Solaris), and
> machine C is where the RMI Connection to Database.
>
> What, I'm doing right now is I'm parsing every elements from the files
> using Oracle Parser and insert it to database using jdbc. But the
> program isn;t using all of the cpus because it's only capable to Parse
> and insert around 18,000 elements / hour, 432,000 elements in 1 day.
> So to parse all of data it will take around 57 days ? It should be
> something wrong here, but I don't have any clue on how to get through
> it.
>
> My only thought is to modified the parsing program, to utilize the 8
> cpus resources.
>
> Can someone guide me how to find resource in Parallelism, so the Parsing
> program will utilize the SMP.
>
> Or if anyone have some advice on the best way to implement it, I really
> appreciate it.
>
> Thanks
Received on Sat Jul 21 2001 - 15:13:43 CDT