that's pretty drastic, I would say -- to disable a nice feature in an unsupported/undocumented way -- just to get some queries slightly faster...
if your database is properly sized, you don't need to check DBA_FREE_SPACE every minute anyway :-) and you can also execute an occasional PURGE RECYCLEBIN command (with DBA privileges) to purge the recycle bin, when "needed."
All in all, the recycle bin is a *very* low price to pay for the recoverability of the "oops" situations, and by setting that hidden parameter you loose that capability.
Locally managed tablespaces also slow down certain queries against the data dictionary -- but that's not a reason to go back to dictionary managed tablespaces, right? ;-)
From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] On Behalf Of Radoulov, Dimitre Sent: Monday, July 18, 2005 15:06 To: oracle-l Subject: Re: BIN$ objects (after media recovery)
With too many objects in the recyclebin the queries on dba_free_space become really, really slow... fortunately you can always disable the recyclebin option:
ALTER SYSTEM SET _recyclebin=FALSE SCOPE=BOTH;
Cheers, Dimitre Radoulov
On 7/18/05, Sinardy <all_about_oracle@(protected)> wrote:
Hi,
Do you know what happen if you continuously drop very big objects without bother to purge your bin? Will that hang the system until you purge those old objects or it is work like round robin.
regards, Sinardy
-- -- Original Message -- -- From: "David Sharples" <davidsharples@(protected) <mailto:davidsharples@(protected)> > To: <bobmetelsky@(protected)> Cc: "oracle-l" <oracle-l@(protected)> Sent: Sunday, July 17, 2005 9:52 PM Subject: Re: BIN$ objects (after media recovery)
> there are your recycle bin objects - purge recycle bin; to clear them > > > or drop table xxx purge; when you drop it oringially > > On 7/17/05, Bob <bobmetelsky@(protected)> wrote: > > win 2000 server - oracle 10.1 - archivelog mode > > > > Ive seen these object names before and research (goggle) suggested they > > were "recovered fragments" > > > > Ive just performed media recovery on a datafile and all objects in that > > datafile now seem to have a corresponding BIN$Xob75zTpRE..... > > name. > > > > What are these BIN$ objects and if they are useless how to get rid of them? > > > -- > http://www.freelists.org/webpage/oracle-l <http://www.freelists.org/webpage/oracle-l> >
-- http://www.freelists.org/webpage/oracle-l
-- -- ---- ---- ---- ---- ---- -- select standard_disclaimer from company_requirements where category = 'MANDATORY';
<!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><FONT face="Courier New" color=#0000ff size=2><SPAN class=546391313-18072005>Hi Dimitre,</SPAN></FONT></DIV> <DIV dir=ltr align=left><FONT face="Courier New" color=#0000ff size=2><SPAN class=546391313-18072005></SPAN></FONT> </DIV> <DIV dir=ltr align=left><FONT face="Courier New" color=#0000ff size=2><SPAN class=546391313-18072005>that's pretty drastic, I would say -- to disable a nice feature in an unsupported/undocumented way -- just to get some queries slightly faster...</SPAN></FONT></DIV> <DIV dir=ltr align=left><FONT face="Courier New" color=#0000ff size=2><SPAN class=546391313-18072005></SPAN></FONT> </DIV> <DIV dir=ltr align=left><FONT face="Courier New" color=#0000ff size=2><SPAN class=546391313-18072005>if your database is properly sized, you don't need to check DBA_FREE_SPACE every minute anyway :-) and you can also execute an occasional PURGE RECYCLEBIN command (with DBA privileges) to purge the recycle bin, when "needed."</SPAN></FONT></DIV> <DIV dir=ltr align=left><FONT face="Courier New" color=#0000ff size=2><SPAN class=546391313-18072005></SPAN></FONT> </DIV> <DIV dir=ltr align=left><FONT face="Courier New" color=#0000ff size=2><SPAN class=546391313-18072005>All in all, the recycle bin is a *very* low price to pay for the recoverability of the "oops" situations, and by setting that hidden parameter you loose that capability.</SPAN></FONT></DIV> <DIV dir=ltr align=left><FONT face="Courier New" color=#0000ff size=2><SPAN class=546391313-18072005></SPAN></FONT> </DIV> <DIV dir=ltr align=left><FONT face="Courier New" color=#0000ff size=2><SPAN class=546391313-18072005>Locally managed tablespaces also slow down certain queries against the data dictionary -- but that's not a reason to go back to dictionary managed tablespaces, right? ;-)</SPAN></FONT></DIV> <DIV><FONT face="Courier New" color=#0000ff size=2></FONT> </DIV> <DIV><SPAN class=546391313-18072005><FONT face="Courier New" color=#0000ff size=2>cheers,</FONT></SPAN></DIV> <DIV><SPAN class=546391313-18072005><FONT face="Courier New" color=#0000ff size=2></FONT></SPAN><FONT size=2><BR><FONT face="Courier New">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> </DIV> <DIV> </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:06<BR><B>To:</B> oracle-l<BR><B>Subject:</B> Re: BIN$ objects (after media recovery)<BR></FONT><BR></DIV> <DIV></DIV> <DIV><FONT face=Arial size=2>With too many objects in the recyclebin the queries on dba_free_space become really, really slow... fortunately you can always disable the recyclebin option:</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>ALTER SYSTEM SET _recyclebin=FALSE SCOPE=BOTH;</FONT></DIV> <DIV><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><FONT face=Arial size=2></FONT> </DIV> <DIV> </DIV> <DIV> </DIV> <BLOCKQUOTE style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> <DIV style="FONT: 10pt arial"><FONT face="Times New Roman" size=3></FONT><BR><BR> </DIV> <DIV><SPAN class=gmail_quote>On 7/18/05, <B class=gmail_sendername>Sinardy</B > <<A href="mailto:all_about_oracle@(protected)">all_about_oracle@(protected)</A>> wrote:</SPAN> <BLOCKQUOTE class=gmail_quote style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hi,<BR><BR>Do you know what happen if you continuously drop very big objects without<BR>bother to purge your bin? Will that hang the system until you purge those <BR>old objects or it is work like round robin.<BR><BR><BR>regards,<BR>Sinardy<BR><BR><BR>-- -- Original Message -- --<BR>From: "David Sharples" <<A href="mailto:davidsharples@(protected)">davidsharples@(protected) </A>><BR>To: <<A href="mailto:bobmetelsky@(protected)">bobmetelsky@(protected)</A>><BR>Cc : "oracle-l" <<A href="mailto:oracle-l@(protected)">oracle-l@(protected)</A>><BR>Sent : Sunday, July 17, 2005 9:52 PM <BR>Subject: Re: BIN$ objects (after media recovery)<BR><BR><BR>> there are your recycle bin objects - purge recycle bin; to clear them<BR>><BR>><BR>> or drop table xxx purge; when you drop it oringially<BR>> <BR>> On 7/17/05, Bob <<A href="mailto:bobmetelsky@(protected)">bobmetelsky@(protected)</A>> wrote:<BR>> > win 2000 server - oracle 10.1 - archivelog mode<BR>> ><BR>> > Ive seen these object names before and   ;research (goggle) suggested they <BR>> > were "recovered fragments"<BR>> ><BR>> > Ive just performed media recovery on a datafile and all objects in that<BR>> > datafile now seem to have a corresponding BIN$Xob75zTpRE..... <BR>> > name.<BR>> ><BR>> > What are these BIN$ objects and if they are useless how to get rid of<BR>them?<BR>> ><BR>> --<BR>> <A href="http://www.freelists.org/webpage/oracle-l">http://www.freelists.org /webpage/oracle-l </A><BR>><BR><BR><BR><BR>--<BR><A href="http://www.freelists.org/webpage/oracle-l">http://www.freelists.org /webpage/oracle-l</A><BR></BLOCKQUOTE></DIV><BR><BR><BR>-- <BR>-- ---- ---- ---- ---- ---- --<BR>select standard_disclaimer from company_requirements where category = 'MANDATORY'; <BR></BLOCKQUOTE></BODY></HTML>
