Ponimaju chto vopros ne prostoj. No nadejus chto on i dlya Vas budet interesnym:

log file sync total_waits rastet primerno na 1000- 1600 v den.

Imeyu 5Mb dlya Redo buffer,
20 RBS x 10Mb,
4 Redo Groups po 16Mb kazchdaja.

Hochu umenschit Redo buffer do 512 K no bojus, chto uvelichitsya kolichestvo sbrosov is RBS v redo logs, chto budet jestcho huzhe.

M.B. imejet kto-libo s Problemoj REDO- Tuning opyt i mozhet chet posovetovat?

danke im voraus.

jesche vopros v tu zhe temu.

Jesli passwort expired, kak skonfigurirovat profile tak, chto-by user ne mog sam passwort izmenit.

Spasibo za pomosch.

ja sobstvenno ob etom i govoril.
Po zaverscheniju Tranzakzii vse chto k nej otnositsy sbrasyvajetsya iz RBS v redo log. Jesli umenshu redo buffer to budet zametno chsche proishodit checkpoint.

Imeju sledujuschju statistiku:

09.12. 10.12. Rost Rost%
undo header count 3134 3172 38 1,212507977
log file sync total_waits 93364 98535 5171 5,538537338
log file switch completion total_waits 531 549 18 3,389830508
log file parallel write total_waits 166554 174537 7983 4,793040095
log file sequential read total_waits 507672 525912 18240 3,592870988
redo log space requests 597 615 18 3,015075377
redo log space wait time 32657 33607 950 2,909024099