Have you bounced the cloned database since the cloning?
Any errors in the alert log?
"Anton Buijs" <aammbuijs_at_xs4all.nl> wrote in message
news:3e0765fb$0$142$e4fe514c_at_news.xs4all.nl...
> What is the total size of the SGA (query V$SGA) of each database?
> How much is that compared to the total memory in the machine?
> Is there sufficient memory remaining for the operating system and file
> system cache?
> Are you sure the response time is not slower in the original db too (when
> both databases are up and running)?
>
> Susan Lam <susana73_at_hotmail.com> schreef in berichtnieuws
> 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 Tue Dec 24 2002 - 10:22:38 CST
