Oracle Enterprise Load-Append - Not inserting in Parallel
Moderators: chulett, rschirm, roy
Oracle Enterprise Load-Append - Not inserting in Parallel
Hi
I tried multiple options to use Enterprise Oracle load with append to do inserts in parallel.
1.OPTIONS(DIRECT=FALSE, PARALLEL=TRUE) with out rebuild index
2.OPTIONS(DIRECT=TRUE, PARALLEL=TRUE,SKIP_INDEX_MAINTENANCE=YES) with rebuild index
The table has unique index and range partition on date with 3 million rows on each date. I searched the forum too.
Control file :
OPTIONS(DIRECT=TRUE,PARALLEL=TRUE,SKIP_INDEX_MAINTENANCE=YES)
LOAD DATA length semantics byte INFILE 'ora.659462.895537.fifo.0' "FIX 973"
APPEND INTO TABLE daily_agg
(
.......
Please let me know if we can do inserts in parallel.
Thanks
Kumar
I tried multiple options to use Enterprise Oracle load with append to do inserts in parallel.
1.OPTIONS(DIRECT=FALSE, PARALLEL=TRUE) with out rebuild index
2.OPTIONS(DIRECT=TRUE, PARALLEL=TRUE,SKIP_INDEX_MAINTENANCE=YES) with rebuild index
The table has unique index and range partition on date with 3 million rows on each date. I searched the forum too.
Control file :
OPTIONS(DIRECT=TRUE,PARALLEL=TRUE,SKIP_INDEX_MAINTENANCE=YES)
LOAD DATA length semantics byte INFILE 'ora.659462.895537.fifo.0' "FIX 973"
APPEND INTO TABLE daily_agg
(
.......
Please let me know if we can do inserts in parallel.
Thanks
Kumar
-
- Premium Member
- Posts: 151
- Joined: Fri Feb 13, 2009 4:19 pm
-
- Premium Member
- Posts: 151
- Joined: Fri Feb 13, 2009 4:19 pm
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Kumar
Please try
$APT_ORACLE_LOAD_OPTIONS=OPTIONS(SKIP_INDEX_MAINTENANCE = TRUE,bindsize=8250000,readsize=8250000,rows=2000)
u can can insert in parallel from datastage based on configuration file
Thanks
Sanjay
Please try
$APT_ORACLE_LOAD_OPTIONS=OPTIONS(SKIP_INDEX_MAINTENANCE = TRUE,bindsize=8250000,readsize=8250000,rows=2000)
u can can insert in parallel from datastage based on configuration file
Thanks
Sanjay
mkiru23 wrote:Does any one has similar situation, how to achieve parallel inserts in oracle enterprise for range partitioned on date and unique index table.ray.wurlod wrote:Is the table partitioned?
Thanks
Kumar
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The site where U is currently working does not use Oracle.
The second person personal pronoun in English is spelled "you", not "u". Please strive for a professional standard of written English on DSXchange, not least to assist those whose first language is not English.
The second person personal pronoun in English is spelled "you", not "u". Please strive for a professional standard of written English on DSXchange, not least to assist those whose first language is not English.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
sanjay wrote:Kumar
Please try
$APT_ORACLE_LOAD_OPTIONS=OPTIONS(SKIP_INDEX_MAINTENANCE = TRUE,bindsize=8250000,readsize=8250000,rows=2000)
u can can insert in parallel from datastage based on configuration file
Thanks
Sanjay
Sanjay,
I tried the job with this change but no difference. I planned a workaround to break the job in one to create a file with SKG and load that file in parallel with parallel option.
Thanks
Kiran