Oracle parallel server, Sequence SYS.DBMS_LOCK_ID

Hello,

 I am observing very high network traffic between the nodes of the ops cluster under some
 circumstances. The nodes generate a good amount of traffic because they all want to access the
 table seq$ (nearly all 10-20ms).

 A closer look at the sequences show that all application sequences are fine, but there is a system
 sequence with a high increasing rate. This sequence is SYS.DBMS_LOCK_ID. The default chache
 value for this sequence seems to be very low.

 Is it possible and save to increase the cache (default 20) for the sequence SYS.DBMS_LOCK_ID or
are there some internals which depends on the default cache value?

 Thanks in Advance
 Fred Stojentin Received on Thu May 20 1999 - 13:40:50 CDT