Home » RDBMS Server » Performance Tuning » query takes so much time to update (oracle 9i)
query takes so much time to update [message #325359] Fri, 06 June 2008 00:25 Go to next message
tannad
Messages: 43
Registered: January 2008
Location: mumbai
Member
I am running the query on oracle 9i sql*plus
/* Formatted on 2008/06/06 10:57 (Formatter Plus v4.8.7) */
UPDATE kone_new a
SET (a.parentid1, a.isparent1, a.childcount1) =
(SELECT b.parentid, b.isparent, b.childcount
FROM konematerial b
WHERE b.zycus_id = a.zycus_id)

In kone_new table there are 5 millions of records ..
what this query running from last 2 days ..but still not updated..
I dropped the indexes on a.parentid1, a.isparent1, a.childcount1
also both tables are in nologging mode..

How to tune this query so that the tables column will updates in less time ,,?
Any suggestion?
If can I analyse the table?

Re: query takes so much time to update [message #325367 is a reply to message #325359] Fri, 06 June 2008 00:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can first read:
- OraFAQ Forum Guide, Performance Tuning section
- How to Identify Performance Problem and Bottleneck
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide

Then provide the requested and usual information.

You can also have a look at Database Performance Tuning Guide.

Regards
Michel
Re: query takes so much time to update [message #325480 is a reply to message #325359] Fri, 06 June 2008 05:45 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
How many records are there in KONEMATERIAL.

It's probably worth having an index on KONEMATERIAL.ZYCUS_ID
Previous Topic: Question on Object Statistics and Query Execution
Next Topic: How to understand query plan
Goto Forum:
  


Current Time: Thu Dec 08 18:45:13 CST 2016

Total time taken to generate the page: 0.18486 seconds