OraFAQ Forum: SQL & PL/SQL » Performance Issue

Home » SQL & PL/SQL » SQL & PL/SQL » Performance Issue

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Performance Issue [message #213100]

Tue, 09 January 2007 08:39

vpoalj
Messages: 3
Registered: January 2007
Location: Bangalore

Junior Member

i have serious problem with the attached script, it is taking hell lot of time, say to update about 2000 records, it is taking about 1:15 mins, at the same time i have to update about 6millions of records...plz help me to sort out the performance issue.

Attachment: XX_CUSTOMER_ORD_PISSUE.sql
(Size: 32.70KB, Downloaded 511 times)

[Updated on: Tue, 09 January 2007 08:58]

Report message to a moderator

Re: Performance Issue [message #213124 is a reply to message #213100]

Tue, 09 January 2007 09:58

Cthulhu
Messages: 381
Registered: September 2006
Location: UK

Senior Member

Your phrasing is a bit unclear. Do you mean you are updating 6 million records using a different application at the same time as running this one, which updates 2000 ? Or do you just mean that this application is currently updating 2000 but is supposed to update 6 million ?

[Updated on: Tue, 09 January 2007 10:01]

Report message to a moderator