No question at this time
DBA Top 10
1 M. Cadot 13000
2 B. Vroman 11900
3 A. Kavsek 11200
4 J. Schnackenberg 5600
4 M. Hidayathullah ... 5600
6 T. Boles 5400
7 P. Wisse 3200
8 T. P 700
9 A. Rai 600
10 R. Wauben 500
10 H. Steijntjes 500
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48147
Total active users1697
Act. users last 24h6
Act. users last hour1
Registered user hits last week261
Registered user hits last month1385
Go up

SQLLoader and RAC
Next thread: exporting oracle tables on command line as sql files
Prev thread: AWR report analysis

Message Score Author Date
I am using SQLLoader to load data exported from a ...... Gerard Vaz Nov 06, 2017, 22:07
You can cut your input file into 4 files, launch...... Michel Cadot Nov 07, 2017, 09:30
Thanks Michel. I don't want to split the input ...... Gerard Vaz Nov 07, 2017, 15:22
I thought you have a single file and a single ta...... Michel Cadot Nov 07, 2017, 16:53
Thanks Michel.... Gerard Vaz Nov 10, 2017, 17:42

Follow up by mail Click here


Subject: SQLLoader and RAC
Author: Gerard Vaz, Canada
Date: Nov 06, 2017, 22:07, 106 days ago
Os info: Linux
Oracle info: Oracle12c
Message: I am using SQLLoader to load data exported from a DB2 environment to an Oracle 4node RAC database.

I do not have access to the Oracle db myself and am working with the DBA to help load the data.

The DBA is executing the scripts on the database server.

Ques 1. Can he/she not split the scripts in batches so that the load is distributed across the 4nodes - as in say running 1 script on each node in parallel? If yes, what exactly needs to be done?

Ques 2. Apart form batching the loads, what else (if at all) needs be done? I have used the 'UNRECOVERABLE' option as well to avoid/minimize redo. I have also used the DIRECT option to facilitate the load.

Does anyone have any other suggestions?

Thanks.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: SQLLoader and RAC
Author: Michel Cadot, France
Date: Nov 07, 2017, 09:30, 106 days ago
Message:
You can cut your input file into 4 files, launch a SQL*Loader session on each instance using the PARALLEL parameter of SQL*Loader.

Note that there are many restrictions on PARALLEL DIRECT loads like indexes are not maintain during the load, constraints have to be disabled... see the documentation.

Regards
Michel


Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: SQLLoader and RAC
Author: Gerard Vaz, Canada
Date: Nov 07, 2017, 15:22, 106 days ago
Message: Thanks Michel.

I don't want to split the input DAT files. Rather I want to have 'n' tables loaded in parallel - with the DAT files untouched.

Also, I do not have indexes and constraints in place. So that
is not an issue.

Gerard
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: SQLLoader and RAC
Author: Michel Cadot, France
Date: Nov 07, 2017, 16:53, 105 days ago
Message:
I thought you have a single file and a single table to load, with multiple files and tables it is easier to parallelize just specify different tables and files for each loader session.

Note that if you use the same file for different sessions then you will have concurrent accesses on it and maybe contention.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: SQLLoader and RAC
Author: Gerard Vaz, Canada
Date: Nov 10, 2017, 17:42, 102 days ago
Message: Thanks Michel.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here