Help Center/ Database and Application Migration UGO/ FAQs/ Product Consulting/ What Should I Do If Data Collection Fails or Is Slow Due to the Small Values of Certain Oracle SGA Parameters?
Updated on 2023-07-25 GMT+08:00
View PDF
Share

What Should I Do If Data Collection Fails or Is Slow Due to the Small Values of Certain Oracle SGA Parameters?

If data collection fails or is slow because certain parameters in the Oracle system global area (SGA) are set to small values, run the following command:

show parameter SGA;

Command output:

NAME                                TYPE        VALUE   
---------------------------- ----------- ------- 
sga_max_size                        big integer 796M    
sga_target                          big integer 0

Contact the database administrator to increase the values of the SGA parameters.

ALTER SYSTEM SET sga_max_size=5G scope=spfile;

ALTER SYSTEM SET sga_target=5G scope=spfile;

The preceding parameter values are for reference only. If their value is too large, more resources are occupied. Contact the database administrator to set the parameters to appropriate values.

For details about the parameters, see the Oracle official documentation.

Parent topic: Product Consulting