Enabling SGA_TARGET
Hi,
I am looking into enabling the SGA_TARGET parameter. The reason for this is that I am unable to use DATAPump to export unless the SGA_TARGET Parameter has been set. (error advises that no streams pool is created and cannot automatically create one) Up until now the SGA parameters have been manually set (I inherited this database from a colleague).
Allowing the database to dynamically handle it's SGA is a tempting prospect, and all the documentation looks to be simplistically straightforward, but I am a bit wary.
Can you advise from personal experience if there are more cons than pros for using this parameter? Also from the documentation it looks as though I can set an SGA_TARGET and then disable this later and go back to manually set parameters, are there any detrimental effects of doing so?
Allowing the database to dynamically handle it's SGA is a tempting prospect, and all the documentation looks to be simplistically straightforward, but I am a bit wary.
Can you advise from personal experience if there are more cons than pros for using this parameter? Also from the documentation it looks as though I can set an SGA_TARGET and then disable this later and go back to manually set parameters, are there any detrimental effects of doing so?
0