Microstate Response-time Performance Profiling (MRPP) . MRPP offers more accurate, more reliable response time performance modeling for any DBMS including Oracle. It's the performance profiling of the future.

MRPP basically consists of the four parts:

• Internals of the current measurement techniques
• Measurement errors in the current measurement techniques
• Correcting errors in the current measurement techniques
• A theoretical research: Microstate Response-time Performance Profiling (MRPP)

Download the paper at OraPub.com.

• Introduction
  • Goal
  •   Prerequisites
• Measurement of Oracle services and waits in OS level
  • Measurement of Oracle services in OS level
  •  Measurement of Oracle waits in OS level
    • Synchronous wait mechanism
    • Asynchronous wait mechanism
    • Timed out wait mechanism
    • FIFO ordered timeouts
    • Non-ordered timeouts
    • Postable Non-ordered timeouts
    • Non-postable Non-ordered timeouts
• Measurement errors
  • Service measurement errors
    • Active service measurement error
    • Active wait measurement errors
    • Latch spinning time
    • Wait-loop
    • Impact of wait-loop
    • Test case
    • Interpretation of test case
    • Average wait-loop elapsed time
    • Average wait-loop CPU time
    • Average wait-loop utilization
    • Average wait-loop impact in system level
  • Wait measurement errors
    • Inactive wait measurement errors
    • Inactive service measurement errors
    • Recurring waits
• Microstate accounting
  • Definition
  • Oracle and Microstate accounting
• Correcting Oracle measurement errors
  • Test environment
    • OS and database
    • Test scripts
    • Running test scripts
    • Overall OS status during the test
    • Statistic values
    • Oracle timed statistics
    • Oracle timed OS statistics
  • Correcting service measurement errors
    • Formulas for correcting service measurement errors
    • total_service_time_in_OS
    • active_wait_measurement_errors
    • real_Oracle_service_time_in_OS
    • Applying formulas to services
    • Finding active_wait_measurement_errors
    • Finding real_Oracle_service_time_in_OS
    • Finding service_measurement_errors
  • Correcting wait measurement errors
    • Formulas for correcting wait measurement errors
    • total_wait_time_in_OS
    • real_Oracle_wait_time_in_OS
    • inactive_wait_measurement_errors
    • inactive_service_measurement_errors
    • Applying formulas to waits
    • Finding real_Oracle_wait_time_in_OS
    • Finding Min. inactive_wait_measurement_errors
    • Finding Max. inactive_service_measurement_errors
    • Breaking down wait measurement errors to timed OS statistics
    • Breaking down real waits to timed statistics
  • Overall impact of measurement errors
• Microstate Response-time Performance Profiling (MRPP)
  • Decision Tree
  • Applying MRPP to Oracle
    • Levels
    • Level 0
    • Formula
    • Definitions
    • Level 1
    • Formulas
    • Definitions
    • Level 2
    • Formulas
    • Definitions
    • Level 3
    • Formulas
    • Definitions
    • Level 4
    • Formulas
    • Definitions
    • Level OSD
    • Sleep fields
• Conclusions
• Acknowledgments
• About the Author
• Index
  • References
  • New terms introduced in this paper
  • New formulas with their variables introduced in this paper
  • New formulas with their statistics introduced in this paper
• Copyright
• Revision History

We would like to thank to the following reviewers for their helps:

• Jonathan Lewis , the author of Practical Oracle8i.
  
• K Gopalakrishnan , one of the leading Oracle Database Performance Consultant in the world.
  
• Tim Gorman , the co-author of Essential Oracle8i Data Warehousing and Oracle8 Data Warehousing books.
  
• Kirtikumar Deshpande , one of the author of Oracle Performance Tuning 101.
  
• Craig Shallahamer , an Oracle performance philosopher who has a special place in the history of Oracle performance management.
• Mehmet Ugur Kuzu , a valuable technical support analyst.
  

They have honored us by reviewing the MRPP.

I also would like to thank to Erdinc Baslik, Mehmet Ugur Kuzu, Esin Yilmaz, Sebahattin Demir, Tolga Ingenc, Fatih Er, Ahmet Guvel, Yahya Aga for their administrative supports.