Re: Re: Application of logfiles
- From: "biti_rainy" <biti_rainy@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 22 Apr 2004 16:35:55 +0800
hi,Robert Blok
i guess the 1536 bytes bytes archived logs may have no useful=
redo , but the 17408 bytes logs have .
>-rw-rw---- 1 oracle users 17408 2004-04-21 15:40
>robert_log_thread0002_seq0000000029.arc
Best regards
yahoo id: feng_chunpei
A new dba from china
---- from the mail-----
>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=3D
>> YES NO
>> 28 2 21-04-2004 15:37:37 21-04-2004=
15:37:43=3D
>> 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=3D
>> YES
>> there are 3 minutes , how do you know the logfile has no=
=3D
>> 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
>----------------------------------------------------------------=
-
>
>.
=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1
----------------------------------------------------------------
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:
