Can't figure this out... procedure conflicts
"Tim C." <[email protected]>
| Newsgroups | gmane.comp.db.oracle.devel |
|---|---|
| Message-ID | <LYRIS-1796914-777015-2002.11.24-20.30.06--gcdod-oracle#[email protected]> |
Thanks in advance to anyone who can shed some light on this, or tell me where to look for some help. I start two processes - P1 and P2. Both should take about X minutes when run alone. Process P1 finishes in X+Y minutes - not surprising because there were two running. However: Process P2 is still running after 2X+Y (actually *much* longer) minutes. More facts: Both of these processes update the same table - but different records. There are many Update statements in both processes. Help! Tim Oracle 9.2.0... Red Hat Advanced Server 2.5 Intel (Dell) 2-processor (Xeon) --- Change your mail options at http://p2p.wrox.com/manager.asp or to unsubscribe send a blank email to [email protected].