Database - RAC/Scalability (MOSC)

MOSC Banner

Static tables duplication in Buffer Cache

edited Aug 22, 2019 2:23PM in Database - RAC/Scalability (MOSC) 1 commentAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center