setting underscore parameters in unsupported -- unless explicitly suggested by Oracle support staff. I do agree this one is pretty "harmless" but the above is true for any parameter that starts with an underscore, regardless how harmless it is. for one thing, these parameters are not tested as thoroughly as the documented ones.
So if Oracle support wants to play it formal, they can refuse to help you because you are running Oracle in an unsupported configuration ...
From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] On Behalf Of Radoulov, Dimitre Sent: Monday, July 18, 2005 15:43 To: Lex de Haan; 'oracle-l' Subject: Re: BIN$ objects (after media recovery)
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=us-ascii"> <META content="MSHTML 6.00.2900.2668" name=GENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=#ffffff> <DIV dir=ltr align=left><SPAN class=256435213-18072005><FONT face="Courier New" color=#0000ff size=2>Hi Dimitre,</FONT></SPAN></DIV> <DIV dir=ltr align=left><SPAN class=256435213-18072005><FONT face="Courier New" color=#0000ff size=2></FONT></SPAN> </DIV> <DIV dir=ltr align=left><SPAN class=256435213-18072005><FONT face="Courier New" color=#0000ff size=2>setting underscore parameters in unsupported -- unless explicitly suggested by Oracle support staff.</FONT></SPAN></DIV> <DIV dir=ltr align=left><SPAN class=256435213-18072005><FONT face="Courier New" color=#0000ff size=2>I do agree this one is pretty "harmless" but the above is true for any parameter that starts with an underscore,</FONT></SPAN></DIV> <DIV dir=ltr align=left><SPAN class=256435213-18072005><FONT face="Courier New" color=#0000ff size=2>regardless how harmless it is. for one thing, these parameters are not tested as thoroughly as the documented ones.</FONT></SPAN></DIV> <DIV dir=ltr align=left><SPAN class=256435213-18072005><FONT face="Courier New" color=#0000ff size=2></FONT></SPAN> </DIV> <DIV dir=ltr align=left><SPAN class=256435213-18072005><FONT face="Courier New" color=#0000ff size=2>So if Oracle support wants to play it formal, they can refuse to help you because you are running Oracle in an unsupported configuration ...</FONT></SPAN></DIV><!-- Converted from text/plain format --><BR> <P><FONT size=2><FONT face="Courier New">kind regards,<BR><BR>Lex.<BR><BR>-- ---- ---- ---- ---- ---- ---- ---- ---- ---- --- -- ---- ---- --<BR>Steve Adams Seminar </FONT><A href="http://www.naturaljoin.nl/events/seminars.html"><FONT face="Courier New">http://www.naturaljoin.nl/events/seminars.html</FONT></A><BR ><FONT face="Courier New">-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -- -- ---</FONT></FONT><FONT face="Courier New"> </FONT></P> <DIV><FONT face="Courier New"></FONT> </DIV><BR> <DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left> <HR tabIndex=-1> <FONT face=Tahoma size=2><B>From:</B> oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] <B>On Behalf Of </B>Radoulov, Dimitre<BR><B>Sent:</B> Monday, July 18, 2005 15:43<BR><B>To:</B> Lex de Haan; 'oracle-l'<BR><B>Subject:</B> Re: BIN$ objects (after media recovery)<BR></FONT><BR></DIV> <DIV></DIV> <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>
