Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re: Difference on ArchiveLog (I'm rewriting the question)

Re: Re: Difference on ArchiveLog (I'm rewriting the question)

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Thu, 08 Jan 2004 06:24:25 -0800
Message-ID: <F001.005DC261.20040108062425@fatcity.com>






Hi!
 
In case this archive growth isn't a coincidence, you should try setting archive_log_trace to see if there's anything extraordinary there, if you don't find anything, compare the contents of different logfiles using dbms_logmnr.
 
Tanel.
 
----- Original Message -----
From: Mauricio Vélez
To: Multiple recipients of list ORACLE-L
Sent: Thursday, January 08, 2004 4:04 PM
Subject: Re: Re: Difference on ArchiveLog (I'm rewriting the question)

Hello everybody thank for your answers,
 
the size I'm talking about is summing up real sizes of archivelogs files, and I had each configuration of redo logs for one week, and the first one was for many months.
 
There was not any change on database objects and the database is small, the summing up real sizes of datafiles is 13G. 
 
I think It not should be happennig, because the archive generation shouldn't be dependent on redolog size. But in this case yes (Could be an Oracle 9i bug?) .
 
Regards
 
Mauricio Vélez


Tanel Poder <tanel.poder.003@mail.ee> wrote:
Is your system overloaded e.g. there is a continuous queue of transactions waiting?
In that case, with bigger redologs, full checkpoints happen less frequently, allowing database to work faster, thus generating more redo.
 
But, othervise, the archive generation shouldn't be dependent on redolog size.
 
How are you measuring your archive size, just counting number of files/entries from v$archived_log or summing up real sizes of archivelogs? (´these may differ noticeably, especially when frequent manual logswitches occur or archive_lag_target is set).
 
Tanel.
 
----- Original Message -----
From: Mauricio Vélez
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, January 07, 2004 10:49 PM
Subject: Difference on ArchiveLog (I'm rewriting the question)

Hello Everybody

 

I’m rewriting the question,

 

Some days ago the database I work on had 3 logfiles that sized 100M and the database was generating 4G of archive daily.

I changed the  size to 20M and the database began to generate 2G of archive daily, then I changed to 50M and It began to generate 3G of archive daily.

 

I think I’ts not logical that archive size change.

 

The database I'm working on is oracle 9i and I'is on Windows NT.

 

Regards

Mauricio Vélez

 


Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes


Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
Received on Thu Jan 08 2004 - 08:24:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US