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 Mon Dec 23 2002 - 13:37:45 CST
