Database - RAC/Scalability (MOSC)

MOSC Banner

What can replace Oracle sequence on RAC environment?

in Database - RAC/Scalability (MOSC) 3 commentsAnswered

There are many production tables in Oracle RAC environment.

In order to log all tables change, there is a table named "LOG_QUEUE". If there is a INSERT/UPDATE/DELETE on a table, the row is copied to the "LOG_QUEUE" table.

Problem is the "LOG_QUEUE" table has a key that has beein genearting by Oracle sequence because the change order in database is very important in the "LOG_QUEUE" table. It was okay in Single Instance. But, soon it should work on RAC environment having two instances.

The Oracle sequence we use has "ORDER" and "CACHE" options. In RAC environment, it will make performance issue.

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center