OraFAQ Forum: Performance Tuning » Inserts, update are taking long to execute. How to tune it?

Home » RDBMS Server » Performance Tuning » Inserts, update are taking long to execute. How to tune it?

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

Inserts, update are taking long to execute. How to tune it? [message #195292]

Wed, 27 September 2006 16:37

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

Report message to a moderator

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

Mahesh Rajendran
Messages: 10707
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?

Report message to a moderator