OraFAQ Forum: Server Utilities » Sql -loader and parallel

Home » RDBMS Server » Server Utilities » Sql -loader and parallel

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sql -loader and parallel [message #74128]

Thu, 16 September 2004 09:55

Nauj
Messages: 33
Registered: February 2004

Member

Hello,

I'm trying to use sql-loader with�parallel option.

I have loaded data with and without parellel but it takes same time. I don't appreciatte a better perfomance with parallel.

In the called to sqlldr i'm adding PARALLEL=TRUE. That is the only change i have made.

Do i have to make any 'alter table' with my Oracle table??.

Any advice will be greatly appreciatted.

Nauj

Report message to a moderator

Re: Sql -loader and parallel [message #74129 is a reply to message #74128]

Thu, 16 September 2004 16:53

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

DOC says

use multiple load sessions executing concurrently on a multiple-CPU system.

Do You have a multiple CPU system?

PARALLEL can be specified on the command line or in a parameter file. It can also be specified in the control file with the OPTIONS clause.

For example, to invoke three SQL*Loader direct path load sessions on the same table, you would execute the following commands at the operating system prompt:

sqlldr USERID=scott/tiger CONTROL=load1.ctl DIRECT=TRUE PARALLEL=true
sqlldr USERID=scott/tiger CONTROL=load2.ctl DIRECT=TRUE PARALLEL=true
sqlldr USERID=scott/tiger CONTROL=load3.ctl DIRECT=TRUE PARALLEL=true

The previous commands must be executed in separate sessions, or if permitted on your operating system, as separate background jobs. Note the use of multiple control files. This allows you to be flexible in specifying the files to use for the direct path load.

How many sessions did you invoke?

parallel option just loads the data in parallel.
Thats it.
There is nothing else specially done.
If you are looking into performance, look into direct path load.
Direct load bypasses many RDBMS layers. So the loading is faster.
But certain restrictions apply to use direct load.
Please refer documentation.

Report message to a moderator

Re: Sql -loader and parallel [message #74131 is a reply to message #74129]

Thu, 16 September 2004 23:15

Nauj
Messages: 33
Registered: February 2004

Member

Thank for your help, Mahesh

I'm working in a IBM multiple CPU system and my table is partiotioned, i think i have a good situation to use parallel.

I'm using both parallel and direct load.

I'll will continue trying...

Report message to a moderator

Previous Topic:	ORA-03113
Next Topic:	sql loader multiple lines

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 09:20:55 CDT 2024