When you follow the Oracle in-memory / optimizer team, then you have probably seen this… Read the postDBMS_INMEMORY_ADVISOR