Oracle Performance Firefighting
by Craig Shallahamer

Get the book here



Craig Shallahamer's Blog

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.
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.

-------------------------------

* Increase the instance parameter, processes. Be careful, as this parameter affects many other instance parameters.

* Increase the number of IMU pools by increasing the _im_pools parameter or increase the shared pool size by increasing the shared_pool_size parameter. These changes only encourage Oracle to create additional latches, so you may want to do some testing by running a script similar to that shown in Figure 7-18.

* Influence IMU memory. You can influence an IMU memory increase by increasing the shared pool size or by shifting other objects out of the shared pool. For example, you could set cursor_space_for_time to false and reduce the number of kept shared pool objects. Be careful! Increasing memory could also increase IMU activity, generating even more stress on the latches. Decreasing memory may decrease latch activity, but it is also likely to increase IMU node-collapsing activity, resulting in more traditional undo block activity, which can also result in increased IO. So before you start attempting to influence IMU memory, give it some serious thought, talk with your colleagues, and do some testing.

©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.


Know what's important before it's too late!

OraPub's
Performance Training

is like no other...





More Class Pics...
Get student testimonials!