Re: Can't figure this out... procedure conflicts
"Padraic Mulligan" <[email protected]>
| Newsgroups | gmane.comp.db.oracle.devel |
|---|---|
| Message-ID | <LYRIS-1796914-788617-2002.12.03-11.00.22--gcdod-oracle#[email protected]> |
You may find using explain plans on your individual SQL statements may highlight possible contention adding indexes can remove this and speed up both procs. You may also be able to carry out batch commits to speed up the overall process. You must first find where both procs are fight for the same resource or info P --- Change your mail options at http://p2p.wrox.com/manager.asp or to unsubscribe send a blank email to [email protected].