Table des matières

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';