vb2wgLGJ1ZmZlciBjYWNoZcrWtq+53MDtyrG1xL2o0unH+s/foaM8YnI+CjxpbWcgc3JjPQ=="https://www.cppentry.com/upload_files/article/57/1_lxtxg__.png" width="700" height="381.551362683" alt="\">
我们以buffer cache advice为例：
select statistics_name,statistics_view_name from v$statistics_level where statistics_name="Buffer Cache Advice';
此时我们禁用SGA自动管理：可以修改参数sga_target,设置为0
SQL> show parameter sga;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 404M
sga_target big integer 264M
SQL> show parameter sga_target;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_target big integer 0
此时我们通过EM：
baffuer cache分了76mb
上面分配信息可以通过sga动态组件查看：
select * from v$sga_dynamic_components；
