| Problem with procedure/DB [message #60304] |
Fri, 30 January 2004 18:51  |
ora
Messages: 47
Registered: June 2002
|
Member |
|
|
Hi,
I am using a procedure which insert data into a single table from an another table according to the parameters passed in proc. (INSERT INTO .. SELECT * FROM ..) and I am not using any explicit locking.
The table in which i am inserting the records having INITTRANS 5 and PCTINCREASE of the table is 0. Plus no concept of row chaining.
Now when i run this procedure everything goes fine, BUT when in parallel means from an another window if i run the same procedure with different parameters it put my DB on knees. I am unable to find out the cause of problem & solution and all of you are requested to pull me out from this. Mainly i just want to know the possible reasons for this so that i can concentrate on it.
Thanx in advance.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
