Assistance with changing memory_target/sga_target and log_buffer
Hello, we've had some recent issues with some services taking up all the processes allocated to our production database. I have downtime to bounce the server tomorrow so I can increase them, but as our actual server is usually showing about 60% of the memory is being used pretty consistently, we also thought we'd increase the memory allocated to the server, and then I could also increase the MEMORY_TARGET parameter. However, now I am reading that for Linux servers, you are actually not supposed to be using MEMORY_TARGET, but instead use SGA_TARGET and PGA_AGGREGATE_TARGET. I had been told a while