Skip to Content
0
Former Member
Oct 23, 2012 at 07:45 AM

Recommended Redolog size

443 Views

Dear all,

I want to check the advised redolog size on my server. I know Oracle 10g has an option for this, and this by using FAST_START_MTTR_TARGET parameter.

For now I have:

SQL> show parameter mttr_target

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

fast_start_mttr_target integer 0

SQL> select optimal_logfile_size from v$instance_recovery;

OPTIMAL_LOGFILE_SIZE

--------------------

Without setting fast_start_mttr_target to a value different to 0, the Redo Logfile Size Advisor won't give you any advice about the optimal size (in MB.) for the redo logfile.

The default is 300 seconds (5 Minutes). and maximum we can give 3600 ( 1 Hour).

But how can I decide which value to give to fast_start_mttr_target ?

Can you please advise ?

Thank you,

Jordy