Based on what I have understood, the objects remain in bin$ until oracle needs to allocate space but no free space is available. Then I think it starts with earliest dropped object. Raj
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)> > 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 >
-- -- ---- ---- ---- ---- ---- -- select standard_disclaimer from company_requirements where category = 'MANDATORY';
<div>Based on what I have understood, the objects remain in bin$ until oracle needs to allocate space but no free space is available. Then I think it starts with earliest dropped object.</div> <div> </div> <div>Raj<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>
