Re: Application of logfiles
- From: Robert Blok <robert.blok@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 22 Apr 2004 09:42:32 +0200
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
