jump to content

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)
  • Free 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 	v$sysstat
where  	NAME in ( 'dirty buffers inspected','free buffer inspected')
and  	VALUE > 0