Hi Lex, I agree that this solution is drastic, but we monitor our production systems with BMC Patrol (with recyclebin the CPU is always on 100% because of the tablespace free space check).
"if your database is properly sized ..."
We are an outsourcing company: many clients, many sistem integrators, too much third party/custom code and load/functionality changing every day, it's really hard to size properly these systems.
"to disable a nice feature in an unsupported/undocumented way ..."
Why undocumented? See Note:265253.1: 10g Recyclebin Features And How To Disable it( _recyclebin ).
Cheers Dimitre Radoulov
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=iso-8859-1"> <META content="MSHTML 6.00.2900.2668" name=GENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=#ffffff> <DIV><FONT face=Arial size=2>Hi Lex,</FONT></DIV> <DIV><FONT face=Arial size=2>I agree that this solution is drastic, but we monitor our production systems with BMC Patrol (with recyclebin the CPU is always on 100% because of the tablespace free space check). </FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><SPAN class=546391313-18072005><FONT face=Arial color=#0000ff size=2>"if your database is properly sized ..."</FONT></SPAN></DIV> <DIV><SPAN class=546391313-18072005><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=546391313-18072005><FONT face="Courier New" size=2><FONT face=Arial>We are an outsourcing company: many clients, many sistem integrators , too much third party/custom code and load/functionality changing every day, it 's really hard to size properly these systems.</FONT> </FONT></SPAN></DIV> <DIV><SPAN class=546391313-18072005><FONT face="Courier New" size=2></FONT></SPAN> </DIV> <DIV><SPAN class=546391313-18072005><FONT face=Arial color=#0000ff size=2>"to disable a nice feature in an unsupported/undocumented way ..."</FONT></SPAN></DIV> <DIV><SPAN class=546391313-18072005><FONT face="Courier New" color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=546391313-18072005><FONT face=Arial size=2>Why undocumented? See Note:265253.1: 10g Recyclebin Features And How To Disable it( _recyclebin ).</FONT></SPAN><SPAN class=546391313-18072005><FONT face=Arial size=2> </FONT></SPAN></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2></FONT><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>Cheers</FONT><BR>Dimitre Radoulov</DIV> <DIV> </DIV> <DIV> </DIV> <DIV> </DIV> <DIV> </DIV></BODY></HTML>
