doc Original: | Author: Steven P. Karniotis| Type: DBA | SubType: | Cible: Block Buffers | Desc: Utilisation des database block buffers par categorie | # Set echo off set termout off set heading off set feedback off column tdate new_value _date noprint column database_name new_value dbname noprint select to_char(sysdate, 'Dy Mon dd, yyyy hh:mi:ss') tdate, upper(v1.value) database_name from v$parameter v1 where v1.name = 'db_name'; set termout on set heading on set feedback on set verify off set linesize 132 set pagesize 60 set newpage 1 column buffer_state format a30 heading "State of|Database Buffer" - justify center column buffer_count format 999,990 heading "Buffer|Count" justify center ttitle left _date center 'Performance Management Report' skip 1 center - 'for Database ' format a8 &&dbname right - 'Page: ' format 999 sql.pno skip 1 - center 'Database Block Buffer Usage' skip 2 select decode(state,0, 'Free', 1, 'Read and Modified', 2,'Read and Not Modified', 3, 'Currently Being Read', 'Other') buffer_state, count(*) buffer_count from x$bh group by decode(state,0, 'Free', 1, 'Read and Modified', 2,'Read and Not Modified', 3, 'Currently Being Read', 'Other'); clear breaks clear columns clear computes ttitle off