RAC 환경에서 sequence 관련 장애가 있어 분석중에 찾은 내용 (don't forget!) sequence cache의 크기를 늘리고, ORDER 보다 NOORDER 로 하는 것이 경합을 줄일 수 있다. (NOCACHE 금지) Generally, sequences can be cached with cache values as high as 200 in RAC. This is much higher than for a regular Oracle instance. If there is insufficient caching, contention can result and will show up as an increase in service times. If there are performance prob..