Objetivo

[margin10]

Analisa a eficiência do Database Buffer Cache.

[margin30]

Script

[margin10]

SELECT
    DECODE(state, 0, 'Free',
                  1, DECODE(lrba_seq, 0, 'Available', 'Being Modified'),
                  2, 'Not Modified',
                  3, 'Being Read',
                     'Other') block_status
  , count(*) count
FROM
  sys.x$bh
GROUP BY
    DECODE(state, 0, 'Free',
                  1, DECODE(lrba_seq, 0, 'Available', 'Being Modified'),
                  2, 'Not Modified',
                  3, 'Being Read',
                     'Other');

[margin30]

Exemplo de saída

[margin10]

BLOCK_STATUS        COUNT
-------------- ----------
Being Modified         40
Available           12445
Being Read            297

[margin10]
[row_fluid][span4]

Avaliação

[im_skill_meter title=”COMPLEXIDADE” style=”view_xs” percent=”40″ placeholder=”rgba(129,215,66,0.1)” color=”#1e73be” label_width=”30″ bar_height=”30″ label_color=”#ffffff” label_bg=”#026abf”]
[im_skill_meter title=”QUALIDADE” style=”view_xs” percent=”30″ placeholder=”rgba(129,215,66,0.1)” color=”#1e73be” label_width=”30″ bar_height=”30″ label_color=”#ffffff” label_bg=”#026abf”]
[im_skill_meter title=”COMPATIBILIDADE” style=”view_xs” percent=”100″ placeholder=”rgba(129,215,66,0.1)” color=”#1e73be” label_width=”30″ bar_height=”30″ label_color=”#ffffff” label_bg=”#026abf”]
[/span4]
[span8]
[toggle_framed framed=”true”]
[toggle title=”AUTOR”]

Autor

Rodrigo Almeida

Site

http://www.rodrigoalmeida.net

Data Publicação

23/09/2012

[/toggle]
[toggle title=”REGRAS”]

3-48 REGRAS

Saiba sobre as regras e padrão de avaliação do banco de scripts aqui.

[/toggle]
[toggle title=”ENVIAR SCRIPT”]

downloading_updates-48 ENVIAR SCRIPT

Recomende um script útil aos DBAs da nossa comunidade aqui.

[/toggle]
[/toggle_framed]
[/span8][/row_fluid]