-
optimal_logfile_size
From a book
A new column optimal_logfile_size is now available in v$instance_recovery.This column shows the redo logfile size in MB which is considered an optimal size
But when i run the following
SQL> select optimal_logfile_size
2 from v$instance_recovery;
OPTIMAL_LOGFILE_SIZE
--------------------
What else i have to check?
can anybody help me in this regard?
thanx in advance
-
You need to set fast_start_mttr_target to get the value.
-
You need to understand the concept of incremental checkpoints and the impact to the instance recovery time and then to decide on that.
I would not say that this is the optimal size, but rather this is the minimal size you need, in order to cjeckpoiint as rare as required by FAST_START_MTTR_TARGET which would theoretically lead to better performance
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|