|
|
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. ------------------------------- Oracle has made tremendous strides in the shared pool. As a result, for every problem a performance analyst is likely to encounter, there are a number of solutions. In fact, Oracle has taken this so seriously that some of the solutions can be invoked with an alter system or even an alter session command. In the coming years, I suspect we'll see even greater things occur in the shared pool. 1 I suspect the trend will continue. As shared pool memory management continues to improve, Oracle will be more confident in placing more and more distinctly different objects into this single large cache. 2 The student registration system that needed bind variables was based on version of Oracle that did not support this transformation option. As a result, the SQL had to be changed. 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!