| DB parameters [message #343596] |
Wed, 27 August 2008 10:55  |
pdhayan@qwest.com
Messages: 6
Registered: August 2008
|
Junior Member |
|
|
Hi,
I'm using bulk collect with Limit to fetch data from source tables &forall to insert data into destination tables thru anonymous pl/sql scripts.
The script works fine when run the script alone but if I run more than one similar scripts the performance degrades
I think some parameter needs to bechanged at instance level
could someone suggest me What are the oracle instance parameter needs to considered when using bulk collect/ forall?
Thanks In advance
Channa
|
|
|
|
|
|
| Re: DB parameters [message #344368 is a reply to message #343596] |
Fri, 29 August 2008 09:41  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
|
Do you mean that the performance degrades when you run several scripts one after another, or when you run several scripts at the same time?
|
|
|
|
| Re: DB parameters [message #344370 is a reply to message #343596] |
Fri, 29 August 2008 09:51 |
pdhayan@qwest.com
Messages: 6
Registered: August 2008
|
Junior Member |
|
|
thanks for looking into the post...
i run 5 to 8 different scripts at the same time which loads data into different tables & the source tables are mostly different. All the scripts uses bulk collect/forall insert
thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
