You were brought to this page based on an internet search
and as a free service to Oracle DBAs.
The text below is an except from the book,
Oracle Performance Firefighting, written by
Craig Shallahamer of
OraPub, Inc.
Figures and tables are not included on this page, only their reference.
To order the book in either print or PDF form, click
here.
©2009, 2010 by Craig Shallahamer. This is copyrighted material.
PleaseOut of respect for those involved in the creation of the book and also for
their familes, we ask you to respect the copyright both in intent and deed. Thank you.
-------------------------------
Figure 3-1 can help differentiate serialization and queuing. In Figure 3-1, the outlined circles represent a CPU. In capacity planning, we call these servers, because they service transactions. The solid circles represent a process. The horizontal outlined rectangle represents the single queue, where all processes enter the system.
Figure 3-1. While serialization and queuing are related, they are distinct. Diagram A shows a classic queuing situation. Diagram B shows a serialization issue because there are idle CPUs. Diagram C is a serialization issue because there are processes queuing while there are idle CPUs.
Diagram A on the left side of Figure 3-1 is the classic queuing situation in which all the servers (think CPUs) are busy servicing transactions, and there are other processes waiting to be serviced. This represents parallelism, as all available servers are involved in processing transactions.
©2009, 2010 by Craig Shallahamer. This is copyrighted material.
PleaseOut of respect for those involved in the creation of the book and also for
their familes, we ask you to respect the copyright both in intent and deed. Thank you.
|