Home » RDBMS Server » Performance Tuning » Inserts, update are taking long to execute. How to tune it?
Inserts, update are taking long to execute. How to tune it? [message #195292] Wed, 27 September 2006 16:37 Go to next message
jiltin
Messages: 44
Registered: September 2002
Member
Based on the review or tkprof, I find that Inserts, update are taking long to execute. How to tune it? The select sqls are fast and ruuning fine, while update and insert execute is taking time.

This system has 1.7GB SGA, with 400 GB datafile size?

What are the option available to tune the inesert or update statements?

Thanks,

Jiltin
Re: Inserts, update are taking long to execute. How to tune it? [message #195297 is a reply to message #195292] Wed, 27 September 2006 16:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
No useful information(Oracle version,stats,concerned code,execution plan etc) to start with.
Are there indexes?
HOw are you loading / inserting the data? Is this a bulk load?
What kind of tablespace is this? What about its storage parameters?

>>insert execute is taking time
May be becuase of presence of indexes.
How are the freelists configured?

>>400 GB datafile size
A single file of 400 gb?
How are the disks spread out? What kind of RAID?

Re: Inserts, update are taking long to execute. How to tune it? [message #195789 is a reply to message #195292] Mon, 02 October 2006 07:27 Go to previous messageGo to next message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
Do you have triggers attached to updated tables?
Re: Inserts, update are taking long to execute. How to tune it? [message #201429 is a reply to message #195789] Sat, 04 November 2006 03:08 Go to previous message
jiltin
Messages: 44
Registered: September 2002
Member
No, there are no triggers, for sure.
Previous Topic: how to change this query, runs forever
Next Topic: insert statement runs slow
Goto Forum:
  


Current Time: Sat Dec 03 01:07:31 CST 2016

Total time taken to generate the page: 0.16713 seconds