<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Re: jboss 5.1 & messaging & Oracle 11g
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/ryanhos">Ryan Hochstetler</a> in <i>JBoss Messaging</i> - <a href="http://community.jboss.org/message/623786#623786">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Our DBA told me that it's a bug in 11g, but it's easily fixed.  The solution is to enable an event in the init.ora file and reboot the system.  It didn't sound like you had a full-time DBA for your project, so I got a few simple instructions from our DBA to help you out.</p><ol><li style="text-align: start;">create pfile from spfile</li><li style="text-align: start;">modify pfile to include the event</li><li style="text-align: start;">startup using new pfile</li><li style="text-align: start;">create spfile from the new pfile  to put new event into spfile for next reboot</li></ol><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>44951 TRACE NAME CONTEXT FOREVER, LEVEL 1024</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>This fix causes ASSM LOB space to batch up reclaim instead of just  reclaiming the requested/required number of LOB chunks. To enable this  fix, set event 44951 to the maximum number of chunks that you would like  to have reclaimed per attempt. The maximum allowed is 1024. Anything  larger becomes 1024. However, if the requested amount of space is larger  than the event’s value, the reclaim will be for the requested amount of  space.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Good luck!</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/623786#623786">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in JBoss Messaging at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2042">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>