Static tables duplication in Buffer Cache
Dear colleagues,
we as a Vendor are currently making new design for our application.
Application have around 900 dynamic tables that can be partitioned by RAC instance
but there are around 100 small tables that are pretty static and configuration but intensively used for read purposes (e.g. table Countries - list of countries).
Usually this tables are in memory thus for me the challenge is the overhead to find the master of the block for such tables.
Correspondingly overhead to push the block owner from one instance to another.
Because the tables are very static (1-10 changes per table per day) I think we can have some optimizations techniques.