Re: tuning redo logs

From: Brian P. Mac Lean <brian.maclean_at_iridiumna.com>
Date: Fri, 15 Jan 1999 19:52:24 GMT
Message-ID: <369F9CA2.8D276386@iridiumna.com>

Several responses in this thread mentioned viewing the frequency of redo log switches. The attached script will do just that and more. The output from said looks as follows:

19980713 13:13:04 Redo Log Switching/Archive Log Generation

History           Page:   1
SYSTEM       Selected Thread:  1     Number of Log History Rows Selected: 100
         Average Time Between Log Switches is 0 Days 9 Hours 8 Minutes 40
Seconds
                                Sort By : First Write Time

                  FIRST                      LOW      HIGH ACTIVE ACTIVE
ACTIVE  ACTIVE
THREAD# SEQUENCE# WRITE TIME             CHANGE#   CHANGE#   DAYS  HOURS

MINUTES SECONDS

------- --------- -------------------- --------- --------- ------ ------
------- -------
      1      6148 06/05/98 10:46:14      5815678   5816050      0      0
0      12
             6149 06/05/98 10:46:26      5816051   5816537      0      0
0      50
             6150 06/05/98 10:47:16      5816538   5817043      0      0
0      22
             6151 06/05/98 10:47:38      5817044   5817646      0      0
0      13
             6152 06/05/98 10:47:51      5817647   5818057      0      5
10      30
             6153 06/05/98 15:58:21      5818058   5818638      2     17
51      56
             6154 06/08/98 09:50:17      5818639   5819569      0      0
32      14
             6155 06/08/98 10:22:32      5819570   5821024      0      0
34      17
             6156 06/08/98 10:56:49      5821025   5821130      0      0
29       1
             6157 06/08/98 11:25:51      5821131   5821184      0      1
3      40
             6158 06/08/98 12:29:31      5821185   5822571      1     22
4      38
             6159 06/10/98 10:34:10      5822572   5828424      0      0
13      19
             6160 06/10/98 10:47:29      5828425   5834278      0      0
15      28
             6161 06/10/98 11:02:58      5834279   5840131      0      0
20      50
             6162 06/10/98 11:23:48      5840132   5843895      1     22

56.........

brian.maclean_at_iridiumna.com

Osvaldo Robles wrote:

> Hi everyone
> I would like to know if there is a formula or a method to determine the
> number of redo logs necessary for a database that handles about 16 million
> records.
>
> thanks in advance

Received on Fri Jan 15 1999 - 13:52:24 CST