RE: BIN$ objects (after media recovery)
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <cichomitiko@xxxxxxxxx>, "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 18 Jul 2005 15:24:05 +0200
Hi Dimitre,
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? ;-)
cheers,
Lex.
------------------------------------------------------------------
Steve Adams Seminar <http://www.naturaljoin.nl/events/seminars.html>
http://www.naturaljoin.nl/events/seminars.html
------------------------------------------------------------------
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxx> 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@xxxxxxxxx
<mailto:davidsharples@xxxxxxxxx> >
To: <bobmetelsky@xxxxxxxxxxx>
Cc: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxx> 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?
> >
> --
> //www.freelists.org/webpage/oracle-l
<//www.freelists.org/webpage/oracle-l>
>
--
//www.freelists.org/webpage/oracle-l
--
------------------------------
select standard_disclaimer from company_requirements where category =
'MANDATORY';
BEGIN:VCARD
VERSION:2.1
N:de Haan;Lex
FN:Lex de Haan
ORG:Natural Join B.V.
TEL;WORK;VOICE:+31.30.2515022
TEL;HOME;VOICE:+31.30.2518795
TEL;CELL;VOICE:+31.62.2955714
TEL;WORK;FAX:+31.30.2523366
ADR;WORK:;;Pieter Breughelstraat 10;Utrecht;;3583 SK;Netherlands
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Pieter Breughelstraat 10=0D=0AUtrecht 3583
SK=0D=0ANetherlands
URL;WORK:http://www.naturaljoin.nl
EMAIL;PREF;INTERNET:lex.de.haan@xxxxxxxxxxxxxx
REV:20040224T160439Z
END:VCARD
Other related posts:
