Home » SQL & PL/SQL » SQL & PL/SQL » Performance Issue
Performance Issue [message #213100] Tue, 09 January 2007 08:39 Go to next message
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.

[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 Go to previous messageGo to next message
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

Re: Performance Issue [message #213184 is a reply to message #213100] Tue, 09 January 2007 14:08 Go to previous messageGo to next message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
Post TKPROF
Re: Performance Issue [message #213569 is a reply to message #213124] Thu, 11 January 2007 05:26 Go to previous messageGo to next message
vpoalj
Messages: 3
Registered: January 2007
Location: Bangalore
Junior Member

No... i am updating in the same application which updates only 2000 records in 1:15 mins.
Re: Performance Issue [message #213570 is a reply to message #213184] Thu, 11 January 2007 05:28 Go to previous message
vpoalj
Messages: 3
Registered: January 2007
Location: Bangalore
Junior Member

FYR
Previous Topic: Oracle Trigger equivalent to SQLServer Trigger
Next Topic: how to check when a materialized view was refreshed last
Goto Forum:
  


Current Time: Wed Dec 07 10:45:34 CST 2016

Total time taken to generate the page: 0.05160 seconds