OraFAQ Forum: Performance Tuning » query takes so much time to update

Home » RDBMS Server » Performance Tuning » query takes so much time to update (oracle 9i)

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

query takes so much time to update [message #325359]

Fri, 06 June 2008 00:25

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?

Report message to a moderator

Re: query takes so much time to update [message #325367 is a reply to message #325359]

Fri, 06 June 2008 00:45

Michel Cadot
Messages: 68664
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

Report message to a moderator

Re: query takes so much time to update [message #325480 is a reply to message #325359]

Fri, 06 June 2008 05:45

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

Report message to a moderator

Previous Topic:	Question on Object Statistics and Query Execution
Next Topic:	How to understand query plan

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 22 22:03:02 CDT 2024