|
|
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. ------------------------------- If you want to make changes, carefully consider their effects, as all direct IMU instance parameters are currently hidden parameters. Eight instance parameters are used to control or affect IMU operations, as listed in Table 7-2. Sets the maximum number of Oracle connections. The greater this value, the greater the number of IMU latches. Multiple tests show that for around every 8.25 processes defined, one IMU latch is created. For example, 800 processes led to 97 latches, 600 processes to 73 latches, 400 processes to 48 latches, and 200 processes to 24 latches. Changing the processes parameter has a cascading effect, since many other Oracle parameters are also based on the processes parameter. Enables or disables IMU. By default, this is set to true. To turn off IMU, set this parameter to false. 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!