Table of Contents

Oracle Performance & Tuning

PGA & SGA

Check current PGA and SGA :

show parameter sga;
show parameter pga;

Sessions & Connections

Show current and maximum sessions :

SELECT
  'Currently, ' 
  || (SELECT COUNT(*) FROM V$SESSION)
  || ' out of ' 
  || VP.VALUE 
  || ' connections are used.' AS USAGE_MESSAGE
FROM 
  V$PARAMETER VP
WHERE VP.NAME = 'sessions';

AWR

AWR Retention period :

select snap_interval, retention from dba_hist_wr_control;

Bloom Filters

https://www.doag.org/formes/pubfiles/8319505/BloomFilters20160812.pdf