RE: dbms_job question ??

-----Original Message-----
From: blair_at_pjm.com [mailto:blair_at_pjm.com] Sent: Thursday, April 27, 2000 10:16 AM
To: Multiple recipients of list ORACLE-L Subject: RE: dbms_job question ??

Thank you Michael. Our log_archive_buffer parameter is currently set to 5. Could you tell me how increasing it will make our archiving faster?

tia,

..tom

> -----Original Message-----
> From: david mu [SMTP:mu_david_at_hotmail.com]
> Sent: Wednesday, April 26, 2000 1:27 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: dbms_job question ??
>
> To make more redo log available by adding more redo logs and bigger size.
> To make the archiving faster, making log_archive_buffer parameter bigger.
>
>
> >From: Michael Boligan <mboligan_at_healthvision.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: RE: dbms_job question ??
> >Date: Wed, 26 Apr 2000 07:26:19 -0800
> >
> >Increase the size of your redo logs.
> >
> >-----Original Message-----
> >Sent: Wednesday, April 26, 2000 9:55 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >We are running Oracle 7.3.2.3 OPS on AIX 4.2.1
> >
> >Our database is 600G and extremely insert-intensive (330M per 15 minutes).
> >
> >During hot backup (which takes 10 hours) all 23 on-line redo logs usually
> >fill
> >and the database stops
> >because they are filling faster than the archive process can copy them to
> >the
> >archive filesystem.
> >
> >Can anyone suggest any Oracle tuning that may help? I cant think of
> >anything.
> >Is there a way (in Unix) to give the archiver an exclusive lock on the
> >archive
> >filesystem during a redo log write?
> >
> >..tom
> >--
> >Author:
> > INET: blair_at_pjm.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
> >--
> >Author: Michael Boligan
> > INET: mboligan_at_healthvision.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> Author: david mu
> INET: mu_david_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Author: 
  INET: blair_at_pjm.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may