...has been and will always be about Oracle Performance Management

OraPub M Solver (v1.0d)

Solving M, when R(cpu) = S / ( 1 - (SL/M)^M) and R(io) = S / ( 1 - (SL/M))

---

Arrival Rate (L):		(work/time) This is the total workload divided by the total time interval.
Service Time (S):		(time/work) This is the total CPU consumption divided by the total workload during the interval.
Queue Time (Q):		(time/work) This is the total non-idle wait time divided by the total workload during the interval.
System Type:	CPU IO	How the arrivals (that is, the workload) stress the system.
Precision Level:	Low Normal High	Your desired precision level and patience.

---

Notes:

• Response Time = Queue Time + Service Time. This is why you do not need to enter the response time. You enter its components.
• M is the number of servers. In this context, a server serves transactions. So a CPU core or an active IO device is a server. In this context a server is not a database server, node, or host.
• This technical paper and presentation will show the need for a tool like this.
• This tool is used in OraPub's Advanced Oracle Performance Analysis course and it's One-Day Performance Seminars.
• This tool can be used in conjunction with the last chapter of Craig's book, Oracle Performance Firefighting.

Questions? Email Craig Shallahamer at craig@orapub.com (be ready for his spam blocker email challange).

Use this tool at your own risk. OraPub, Inc. is not responsible for its use or application.