As we have seen, in most cases of SGA tuning, we tend to increase the shared pool size or increase the number of db block buffers.
What are the filp side disadvantages of simply having a large shared pool/increased no. db block buffers??
Can someone please explain some precise points of what the disadvatage is and why? Really appreciate your time and patience.