Thanks Lex, I thought that if a parameter is documented (even if an _parameter), it was supported.
So if it's not, I agree that it's not a good idea to set it unless explicitly suggested by Oracle support staff.
Regards Dimitre Radoulov
-- -- Original Message -- -- From: Lex de Haan To: cichomitiko@(protected) ; 'oracle-l' Sent: Monday, July 18, 2005 5:17 PM Subject: RE: BIN$ objects (after media recovery)
Hi Dimitre,
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=iso-8859-1"> <META content="MSHTML 6.00.2900.2668" name=GENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=#ffffff> <DIV><FONT face=Arial size=2>Thanks Lex,</FONT></DIV> <DIV><FONT face=Arial size=2>I thought that if a parameter is documented (even if an _parameter), it was supported.</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT size=2><FONT face=Arial>So if it's not, I agree that it's not a good idea to set it unless explicitly suggested by Oracle support staff.</FONT></FONT></DIV> <DIV><FONT face=Arial size=2></FONT><FONT face=Arial size=2></FONT><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>Regards</FONT><BR>Dimitre Radoulov</DIV> <DIV> </DIV> <DIV> </DIV> <DIV> </DIV> <DIV> </DIV> <BLOCKQUOTE dir=ltr style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> <DIV style="FONT: 10pt arial">-- -- Original Message -- -- </DIV> <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B> <A title=lex.de.haan@(protected) href="mailto:lex.de.haan@(protected)">Lex de Haan</A> </DIV> <DIV style="FONT: 10pt arial"><B>To:</B> <A title=cichomitiko@(protected) href="mailto:cichomitiko@(protected)">cichomitiko@(protected)</A> ; <A title=oracle-l@(protected) href="mailto:oracle-l@(protected)">'oracle-l'</A> </DIV> <DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, July 18, 2005 5:17 PM</DIV> <DIV style="FONT: 10pt arial"><B>Subject:</B> RE: BIN$ objects (after media recovery)</DIV> <DIV><BR></DIV> <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></BLOCKQUOTE></BODY></HTML>
