How is Data Buffer Quality determined?
Determining the ratio of physical reads and logical reads on the basis of V$SYSSTAT: (1 – “physical reads” / “session logical reads”) * 100 b) Determining the ratio of physical reads and logical reads on the basis of V$SYSSTAT, in which direct reads are not considered, since the data buffer is not read in direct reads. (1 – (“physical reads” – “physical reads direct” – “physical reads direct (lob)”) / (“session logical reads” – “physical reads direct” – “physical reads direct (lob)”) * 100 c) Determining the ratio of physical reads and logical reads on the basis of V$BUFFER_POOL_STATISTICS, in which direct reads are generally not considered in this view: (1 – PHYSICAL_READS / (DB_BLOCK_GETS + CONSISTENT_GETS)) * 100 Transaction ST04 uses method a) while transaction ST04N uses method b). When there are many direct reads (parallel query, lobs, PSAPTEMP access, …), the hit ratio issued by ST04N can be significantly better than the ST04 hit ratio. Method c) delivers similar results as me
Related Questions
- My cath lab participates in the NCDR™. How does the ACC-CathKIT® help me use my NCDR data to improve quality?
- My cath lab participates in the NCDR™. How does the ACC-CathKIT® help me use my NCDR data to improve quality?
- Will PreMIS be usable by local systems to query data and generate system and quality management reports?
- How do I change Data Collection from polling the Buffer Box on Com 1 to polling the Buffer Box on Com2?
- How do I change Data Collection from polling the Buffer Box on Com 1 to polling the Buffer Box on Com2?
- How is Data Buffer Quality determined?
