Set Feedback Off
Set Echo Off
Set Heading Off
Set Term Off

Column Instance New_Value _Instance NoPrint
SELECT 'OLG_' || name Instance FROM v$database;

spool &&_instance..txt

-- Get-Miss Latches

select decode(gets-misses,0,1,gets-misses)/
decode(gets,0,1,gets) hit_ratio
from v$latch where name = 'redo allocation';

spool off;
Set Feedback On
Set Echo On
Set Heading On
Set Term On

exit;