ballioballi
asked on
Can Increasing SGA size cause paging !
The SGA size was 5GB and database was running very fine with no performance issues. we changed to the new server with 16 GB of RAM on AIX 5.3 and we allocated 12 GB for SGA MAX SIZE. and allocated 10GB to shared pool. we are experiencing high paging when running RMAN backup's and even a simpleselect statement takes 2-3 minutes(like select name from v$database). As I allocated this memory to the new server and is in production I am not sure that sga can be a problem.
when we run backup's the disk IO is more and the server is paging.
when we run backup's the disk IO is more and the server is paging.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
did not get the exact answer
What would have been the exact answer then?
First I don't understand why you increased the SGA as it was running very fine with no performance issues...
10GB for the shared pool is so huge ! Do you expect to have 1GB of sql statements (not data, statements) frequently used ?
An oracle server should not swap. You need to have all memory structures (SGA but also PGA) in physical memory.
Regards,
Franck.