ORA-4031 after enabling Dynamic SGA
Old SGA Setting:
*.sga_max_size=1948225392
*.shared_pool_size=939524096
*.shared_pool_reserved_size=92776955
*.java_pool_size=67108864
*.large_pool_size=8388608
*.streams_pool_size=50331648
*.db_cache_size=939524096
Enabled dynamic SGA by adding SGA_TARGET and retaining the other *pool size for the minimum allocation: Only Changes in the spfile were:
*.sga_max_size=1936M
*.sga_target=1936M
After the above change, 30 minutes into a client copy we started receiving ORA-4031 and the DB was in accessible. I had to abort the database.