Database Tuning (MOSC)

MOSC Banner

modify cache_size in sequences before RAC migration

edited Jun 17, 2015 8:22AM in Database Tuning (MOSC) 5 commentsAnswered ✓

Hello,

I plan to migrate single instance 11g to RAC 11g database and gi. I read than one point to consider before migrate, is increment cache_size to avoid waits in the interconnect between instances.

SQL> select cache_size,count(*) from dba_sequences group by cache_size order by 1 desc;

CACHE_SIZE   COUNT(*)

---------- ----------

     10000          6

      8192          1

      1000          6

       300          1

       100         53

        50          2

        20        337

        10         17

         5          1

         2          5

         0        117

We have a lot of schemas than have sequences with cache size lower tan 500...

Will it be worth to increase the cache size in sequences of SYS, SYSTEM and other system users?

SQL> select sequence_owner, count(*) from dba_sequences where cache_size<500 group by sequence_owner order by 2 desc;

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