Administration Workshop II 8-21. Manually tuning pool sizes
SELECT SUM(bytes)/1024/1024 size_mb
FROM v$sgastat WHERE pool = 'shared pool';
Determine the size for the autotuned component in the SGA
SELECT component, current_size/1024/1024 size_mb
FROM v$sga_dynamic_components;
No Comments Yet
Be the first to comment!
