Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: cloned database slower
Hi Susan,
Your problem can have many causes. Here are a few of the more obvious ones :
select * from v$parameter;
and compare the results. Any deviations should be examined.
3) Do you have the same session parameters on both queries? If you have something like OPTIMIZER_GOAL = FIRST_ROWS on the first one and not the second one, it could easily explain the whole deviation.
4) The O/S may, for some O/S reasons, give more ressources to the original DB.
susana73_at_hotmail.com (Susan Lam) wrote in message news:<7186ed56.0212231104.50360850_at_posting.google.com>...
> I've copied/cloned a database to another unix filesystem on the SAME
> server. I did it by copying datafiles over then reconstruct control
> files. Now the user is complaining the cloned database is
> significantly slower than original database! We have a complicated
> query it takes 1 hour in original db but 3 hours on cloned database.
>
> The init.ora parameters are exactly the same except database name,
> location of archive, control files... The nature of filesystem is
> exactly the same. And they are in the same Sun Solaris server. The
> CPU is pretty much at the same state when we did the comparison test.
>
> Any idea? Will cost base stat copy over after cloning?
>
> Thanks,
> Susan
Received on Thu Dec 26 2002 - 06:29:12 CST