While running multiple session in parallel which loads data in the same table, throughput of each session becomes very less and almost same for each session. How can we improve the performance (throughput) in such cases?

  • Interview Candidate
  • 1
  • 3724

Showing Answers 1 - 1 of 1 Answers

Uma Bojja

  • May 3rd, 2006
 

I think this will be handled by the database we use.

When the operations/loading on the table is in progress the table will be locked.

If we are trying to load the same table with different partitions then we run into rowID erros if the database is 9i and we can apply  a patch to reslove this issue

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions