Re: HELP! Need Archivelog Info

terryg8 (trg_at_ibm.net) wrote:
: Dave Schweisguth wrote:
: > terryg8 (trg_at_ibm.net) wrote:
: > : TC1Simp wrote:
: > : > What are the pro's and con's of using ARCHIVELOG? [...]
: > :
: > : In simplistic terms, if you are running in archive mode you can
: > : recover, in the event of catastrophe, from last backup up to the crash
: > : time [...] Archiving is io intensive by nature but most shops consider
: > : it essential.
: > :
: > : Sounds like your programmer is concerned about hardware resources i.e.
: > : not enough cpu or disk. Archiving just isn't that hard to set up so why
: > : not try it and see if the concerns are justified?
: >
: > We did just that, and our performance dropped by a factor of many. Is this
: > normal?
:
: Not in my experience, unless your system is reeeeaaaalllllyyy io bound.

It is, I'm afraid, whether in or out of archivelog.

: Follow up on this thread referencing Thomas Kite of Oracle, he would
: certainly be able to give you a better analysis than I could.

Any quick comments, Tom?

Cheers,

--
| Dave Schweisguth                     CuraGen Corp., Bioinformatics Dept. |
| dcs_at_proton.chem.yale.edu             New Haven, Connecticut              |
| http://home.earthlink.net/~dschweisguth/         My opinions are my own. |
| For compliance with the NJ Right to Know Act: Contents partially unknown |