Hi,
when settings primary vs. secondary logs there is general rule to use primary logs, according to database snapshot info. But what is recommendation to use primary logs? Should I use multiple small primary logs or small amount of big primary logs.

Variant 1:
LOGFILSIZ = 10000
LOGPRIMARY = 4
disk primary log capacity = LOGFILSIZ * LOGPRIMARY = 40000 pages

or

Variant 2:
LOGFILSIZ = 2000
LOGPRIMARY = 20
disk primary log capacity = LOGFILSIZ * LOGPRIMARY = 40000 pages

When should I choose variant 1 (so small amount of big logs) and when variant 2 (multiple small files).

Thanks

Pawan

Variant 1:LOGFILSIZ = 10000
LOGPRIMARY = 4
disk primary log capacity = LOGFILSIZ * LOGPRIMARY = 40000 pages

In the Variant 1 you will have more perform

Variant 2:
LOGFILSIZ = 2000
LOGPRIMARY = 20
disk primary log capacity = LOGFILSIZ * LOGPRIMARY = 40000 pages

In the Variant 2 the time spent to archive logs will be less and in the case of crash recovery the recovery operation will be faster.