|
|
by Craig Shallahamer Get the book here |
|
|
Craig Shallahamer's Blog
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. Please—Out 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. ------------------------------- Now let's relate Oracle's latch acquisition algorithm and time accounting to a real-life Oracle system. Figure 3-9 is not based on queuing theory, and it is not a model. Figure 3-9 is based on actual data sampled from a real Oracle system. A heavy logical IO load was placed on a single four-core CPU Oracle Database 10g Release 2 Linux system. Six 3-minute samples were taken at each load, and then the load was incremented with another three Oracle sessions. The graph in Figure 3-9 shows the following: * The horizontal axis is the incremental load placed on the system-in this case, the number of concurrent synthetic users. Please—Out 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. |
Know what's important before it's too late!
OraPub's
Performance Training
is like no other...
More Class Pics...
Get student testimonials!