OraFAQ Forum: Performance Tuning » slow insert/update

Home » RDBMS Server » Performance Tuning » slow insert/update - same schema on two servers

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

slow insert/update - same schema on two servers [message #179405]

Tue, 27 June 2006 05:37

SASA
Messages: 3
Registered: June 2006
Location: Sarajevo

Junior Member

Hi,

I have a schema that works fine on one server and very slow (insert/update) on another.

Server 1 configuration:
OS: Win2000 server
CPU: 3GHz
RAM: 1 Gb
Server 2 configuration(test):
OS: Win XP
CPU: 3,4GHz
RAM: 1 Gb

Oracle database 9.2.0.1 on every machine, with same database parameters (attached)

Inserting 7000 records, in a table, takes 2 min on server 1 and
over 30 min (3 rows/sec)
There are enough free space in user, temp and undo tablespaces.

Please help!

Attachment: ora_param.xls
(Size: 58.50KB, Downloaded 2077 times)

Report message to a moderator

Re: slow insert/update - same schema on two servers [message #179412 is a reply to message #179405]

Tue, 27 June 2006 05:50

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Are those schemas equal (for example, did you create a Test schema using EXP/IMP utilities so that it is an exact copy of a Production schema)?

Are there, perhaps, database triggers in a Test schema which do something and it slows things down?

Do you insert records directly, or through database link? What does explain plan say?

Report message to a moderator

Re: slow insert/update - same schema on two servers [message #179420 is a reply to message #179412]

Tue, 27 June 2006 06:11

SASA
Messages: 3
Registered: June 2006
Location: Sarajevo

Junior Member

schema are equal (exp/imp, then procedures compiled)

How to use explain plan on a procedures in package that inserts/updates my tables?

Report message to a moderator

Re: slow insert/update - same schema on two servers [message #179515 is a reply to message #179420]

Tue, 27 June 2006 15:51

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm afraid I don't know the answer to this question ... perhaps pulling insert/update statements out of procedures and running them as separate SQL statements?

By the way, is this the case every time it is run, or did it happen occasionally? Was the Test server very busy at the time (for example, many developers running their scripts at the same time)?

Report message to a moderator

Re: slow insert/update - same schema on two servers [message #179582 is a reply to message #179405]

Wed, 28 June 2006 02:12

SASA
Messages: 3
Registered: June 2006
Location: Sarajevo

Junior Member

It happens every time and only one developer runs this script.
I'll try to use sql trace and tkprof or some Toads tools and post the results

Thanks

Report message to a moderator

Previous Topic:	Query performance: Hard code values vs. parmeterized values
Next Topic:	RedoLog Contention

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 07 04:12:18 CST 2025