Skip to Main Content
  • Questions
  • FAST_START_MTTR_TARGET parameter for OLTP

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Bolat.

Asked: January 19, 2017 - 2:22 pm UTC

Last updated: January 21, 2017 - 4:39 am UTC

Version: 11.2.0.4

Viewed 1000+ times

You Asked

We have database using OLTP system (document management system OPENTEXT).
There is a lot of transactions occur inside database.

Sequentially, we get a lot of messages as -
Thread 1 cannot allocate new log, sequence 13124
Private strand flush not complete
...
...
...

I read a lot about right redo log sizing - but I have not found effective way yet.
I came across the parameter - fast_start_mttr_target

Also when chose 'Sizing Advice' in Oracle Enterprise manager for optimal redo log size - it says:
The database cannot recommend the optimal redolog file size. Please set the initialization parameter FAST_START_MTTR_TARGET.

Can we enable that parameter, where Oracle recommends to enable it basing on article -
http://www.dba-oracle.com/oracle_tips_sizing_advisor.htm?

If there are any best practices for that parameter for OLTP systems?
If answer is yes, we can enable it - what value should we set?

With regards!

and Connor said...

See this previous AskTom question for information about private strands

https://asktom.oracle.com/pls/asktom/f?p=100:11:::NO:RP:P11_QUESTION_ID:9529265900346002171

because you might *not* need to resize your redo logs based on the information in there.

But if you want to set FAST_START_MTTR_TARGET, you can check this link for some recommendations on setting a value

http://docs.oracle.com/database/121/TGDBA/pfgrf_instance_tune.htm#TGDBA94557



Is this answer out of date? If it is, please let us know via a Comment