modify cache_size in sequences before RAC migration
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;