RMAN backups causing system to be unresponsive
Need some help here. I inherited a system in which has about 65GB of memory, Linux 64-bit - 16 processors. Every time an RMAN backup is run, nothing else can be done. The load average is around 10(max). My theory is that it's the init.ora parameters, but not sure.. The following is the case:
sga_max_size=47GB
sga_target=0
shared_pool_size=5G
java_pool_size=1G
large_pool_size=0
db_cache_size=38G
I will look into what I need to change. I just wanted to get others opinions since I have inherited a hornet's nest and need some pretty good evidence before being allowed to change any parameters. Any documents, Metalink articles, etc. that you can provide to support a change in these parameters would be great. Thanks.