Re: Application of logfiles

From: Robert Blok <robert.blok_at_xs4all.nl>
Date: Thu, 22 Apr 2004 09:42:32 +0200
Message-ID: <40877768.1000809@xs4all.nl>

Please keep in mind that this is a test. I switched logfiles myself. There actually is almost nothing in them, because I am the only user on the system and did some switches myself. Of course there is always some background redo logging.

As you can see below there is almost no logging in the files (the redo files actually are 100M).

-rw-rw---- 1 oracle users 1536 2004-04-21 15:36 robert_log_thread0001_seq0000000027.arc
-rw-rw---- 1 oracle users 2560 2004-04-21 15:37 robert_log_thread0001_seq0000000028.arc
-rw-rw---- 1 oracle users 2560 2004-04-21 15:37 robert_log_thread0001_seq0000000029.arc
-rw-rw---- 1 oracle users 1536 2004-04-21 15:37 robert_log_thread0002_seq0000000027.arc
-rw-rw---- 1 oracle users 1536 2004-04-21 15:37 robert_log_thread0002_seq0000000028.arc
-rw-rw---- 1 oracle users 17408 2004-04-21 15:40 robert_log_thread0002_seq0000000029.arc
-rw-rw---- 1 oracle users 24064 2004-04-21 15:40 robert_log_thread0001_seq0000000030.arc
-rw-rw---- 1 oracle users 3584 2004-04-21 15:41 robert_log_thread0002_seq0000000030.arc

biti_rainy wrote:
> hi,Robert Blok
>
> thread 2 :
> 27 2 21-04-2004 15:37:31 21-04-2004 15:37:37=
> YES NO
> 28 2 21-04-2004 15:37:37 21-04-2004 15:37:43=
> YES NO
> ONLY 6 seconds , the logfile has no redo
> 29 2 21-04-2004 15:37:43 21-04-2004 15:40:48 YES=
> YES
> there are 3 minutes , how do you know the logfile has no =
> redo ?
> maybe some backgroud process generate redo ?
>
> how big are the archived logs ? they have the same bytes ?
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Apr 22 2004 - 02:38:20 CDT