Finding out the amount of memory utilised by Oracle database...
Hi,
I have just moved one of our oracle databases (10.2.0.4) from one server (OS-->Solaris 9) to another server (OS-->Solaris 10).
The migration was successful but then we are getting performance issue on the new server. I did a test where i carried out an import of a table of size 5 GB on both servers.
Time taken on current server =55 min
Time taken on new server =3 hr 37 min
Memory utilisation is 100% on the new server.
Actually my concern is that i want to find out whether the problem is with the database. Currently the SGA size is 1000M aand it's being tuned automatically.
How can i find out how much memory is being utilised by the database. Is there a query i can run?
Thanks,
Poonam