Major performance difference between two Oracle database instances
Posted
by jrdioko
on Stack Overflow
See other posts from Stack Overflow
or by jrdioko
Published on 2010-04-19T21:51:35Z
Indexed on
2010/04/19
22:53 UTC
Read the original article
Hit count: 290
I am working with two instances of an Oracle database, call them one
and two
. two
is running on better hardware (hard disk, memory, CPU) than one
, and two
is one minor version behind one
in terms of Oracle version (both are 11g). Both have the exact same table table_name
with exactly the same indexes defined. I load 500,000 identical rows into table_name
on both instances. I then run, on both instances:
delete from table_name;
This command takes 30 seconds to complete on one
and 40 minutes to complete on two
. Doing INSERTs and UPDATEs on the two tables has similar performance differences. Does anyone have any suggestions on what could have such a drastic impact on performance between the two databases?
© Stack Overflow or respective owner