No question at this time
DBA Top 10
1 M. Cadot 17900
2 A. Kavsek 15900
3 M. Hidayathullah ... 9200
4 B. Vroman 8600
5 T. Boles 4900
6 P. Wisse 4700
7 J. Schnackenberg 3800
8 K. Van Nieuwenhov... 2100
9 G. Van Cauter 1400
10 A. Hudspith 800
10 T. P 800
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 users48079
Total active users1704
Act. users last 24h9
Act. users last hour0
Registered user hits last week295
Registered user hits last month1831
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, 16 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, 15 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, 15 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, 15 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, 12 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