Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DAX fallbacks

Martin PRESSLABERJul 24 2018 — edited Aug 11 2018

Hi,

could you explain what DAX fallbacks mean in detail and how to avoid them? Or is it ok to have fallbacks?

Unfortunately googling does not help...

MANpage says: fallbacks == Number of commands completed by the software, which DAX could not complete

OK, but why and what does it mean for the DB?

Running RAC on M7 with InMemory:

1st node=DAX commands 35.608.411 with 18 fallbacks

2nd node=DAX commands 63.563.607 with 2.656.188 fallbacks

Is it just a bad day for the second node? Any ideas how I could dig deeper at OS or DB level?

Thanks in advance and regards

- Martin

Comments

JohnGoodwin

I don't think you can without recreating the instance.

Cheers

John

Alex1

Thanks @"JohnGoodwin"

How can I recreate the instance?

JohnGoodwin
Answer
Marked as Answer by Alex1 · Sep 27 2020
Alex1

Thanks for your help.

I have applied recreate command and then restore my backup and it works perfect. I don't see old period mapping.

For me it's ok.

Thanks!

1 - 4

Post Details

Added on Jul 24 2018
7 comments
1,065 views