When is the time to increase the SGA size.
Folks,
I have a simple question, not sure if the answer is that simple.
When you go live/production , you start with your database SGA of certain size.
Over time, let's say, your database grows data wise, i.e. you are storing more data in your data.
Please note, I am not saying your database usage in terms of number of users etc has increased, just that your data volume
stored in the database has increased.
When and how, you figure out that you should increase the size of your database SGA ?
Is it when you start hear users complaining or is there a proactive way, to figure out if the SGA needs to increase etc.
I have a simple question, not sure if the answer is that simple.
When you go live/production , you start with your database SGA of certain size.
Over time, let's say, your database grows data wise, i.e. you are storing more data in your data.
Please note, I am not saying your database usage in terms of number of users etc has increased, just that your data volume
stored in the database has increased.
When and how, you figure out that you should increase the size of your database SGA ?
Is it when you start hear users complaining or is there a proactive way, to figure out if the SGA needs to increase etc.
0