查看当前sga的当前大小,最大大小,最小大小,以及当前已有的组件
SELECT components,current_size,max_size,min_size FROM v$sga_dynamic_component;
确定以为当前程序缓冲区分配了多大大小
SELECT name,value FROM v$pgastat WHERE name in ('max PGA allocated','total PGA allocate');
查看当前sga的当前大小,最大大小,最小大小,以及当前已有的组件
SELECT components,current_size,max_size,min_size FROM v$sga_dynamic_component;
确定以为当前程序缓冲区分配了多大大小
SELECT name,value FROM v$pgastat WHERE name in ('max PGA allocated','total PGA allocate');