Home » RDBMS Server » Performance Tuning » DB parameters (ORacle 10.2.0.3)
DB parameters [message #343596] Wed, 27 August 2008 10:55 Go to next message
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 #343604 is a reply to message #343596] Wed, 27 August 2008 11:11 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

_bulk_collect_fast=true



Re: DB parameters [message #344368 is a reply to message #343596] Fri, 29 August 2008 09:41 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: help in tuning query
Next Topic: unstable sort is inapprehensible (merged)
Goto Forum:
  


Current Time: Mon Dec 05 08:39:41 CST 2016

Total time taken to generate the page: 0.05361 seconds