DBA Scripts - Very Useful - 12. Miscellaneous Reports

Miscellaneous Reports

Here are some scripts related to Miscellaneous Reports .

Write Request Queue

AVERAGE WRITE REQUEST QUEUE LENGTH NOTES:

  Summed Dirty Queue Length - Value for summed dirty queue length (total)

  Write Requests - Value for write requests (total)

  Write Request Queue Length - Average request queue length

select       sum(decode(NAME,'summed dirty queue length',VALUE,0)) summed_dirty_queue_length,

               sum(decode(NAME,'write requests',VALUE,0)) write_requests,

               sum(decode(NAME,'summed dirty queue length',VALUE,0)) / 

               sum(decode(NAME,'write requests',VALUE))  write_request_queue_length

from        v$sysstat

where       NAME in ('summed dirty queue length','write requests')

and          VALUE > 0

Lazy DBWR Indicators

LAZY DBWR INDICATOR NOTES:

  Dirty Buffers Inspected - Value for dirty buffers inspected (total)

  Dirty Buffers Inspected - Value for free buffers inspected (total)

select  sum(decode (NAME, 'dirty buffers inspected', VALUE)) dirty_buffers_inspected,

               sum(decode (NAME, 'free buffer inspected', VALUE)) free_buffers_inspected

from        

Lazy DBWR Indicators

where       NAME in ( 'dirty buffers inspected','free buffer inspected')

and          VALUE > 0