分配一个总的大小,Oracle决定database buffer cache,shared pool,large pool,and java pool. SGA_TARGET,STATISTICS_LEVEL SET TO TYPICAL.
set SGA_TARGET =0 disables automatic shared memory management.
SQL> show parameter SGA_TARGET
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_target big integer 160M
SQL> show parameter statistics_level
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
statistics_level string TYPICAL
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/7301064/viewspace-417715/ ,如需转载,请注明出处,否则将追究法律责任。