Re: Using oracle dump (quickly!)

Hi Sybrand,

  Users can check Steve Adam's website.

  May I request you to post some doc on 1MB upper limit for LOG_BUFFER size?

  Ron
  DBA Infopower
  http://www.dbainfopower.com
  Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html

   I gave you a reference
<sybrandb_at_yahoo.com> wrote in message
news:a1d154f4.0402250146.118ac387_at_posting.google.com...
> "Ron" <support_at_dbainfopower.com> wrote in message
news:<OMydnS8rJbr_HabdRVn-uw_at_comcast.com>...
> > > Usually a buffer parameter of 8M is more than sufficient
> >
> > I use 100M+ as well - always works. Hope user can decide if bigger is
> > better
> >
> > > Setting LOG_BUFFER too anything
> > > higher than 1M is useless, as the buffer is written to disk when 1M is
> > > dirty.
> >
> > As far as I remember, 1M is upper bound for _log_io_size under Oracle8
> > (according to Steve Adams as well). _log_io_size is 1/3 of the log
buffer
> > expressed in log blocks. So setting to LOG_BUFFER 4M during the big
import
> > would not hurt
> >
>
> Evidently your memory is failing you and you didn't review the docs as
> I requested. There is an upper limit of 1Mb. So setting LOG_BUFFER to
> 4M doesn't have ANY impact. Could you please verify and provide proof
> for anything you post? So far you have only provided incorrect advice
> and made an utter fool of yourself.
>
> Sybrand Bakker
> Senior Oracle DBA
Received on Wed Feb 25 2004 - 11:35:36 CST