====== Oracle : Informations mémoire ====== \\ ==== infos SGA ==== SHOW SGA; SELECT * FROM v$sgainfo; ==== Infos PGA ==== SELECT SUM(pga_used_mem) FROM v$process; SELECT * FROM V$PGASTAT ==== Infos Process ==== SHOW PARAMETER processes; SELECT * FROM V$BGPROCESS WHERE paddr <> '00';
SHOW SGA; SELECT * FROM v$sgainfo;
SELECT SUM(pga_used_mem) FROM v$process; SELECT * FROM V$PGASTAT
SHOW PARAMETER processes; SELECT * FROM V$BGPROCESS WHERE paddr <> '00';