Re: Sequence/Trigger problem

Hi Alan, Dirk,

What if I use:

CREATE SEQUENCE USERS_SEQ START WITH 1 INCREMENT BY 1 NOCACHE; Is it then better? How does this affect the performance of insert's? If I use CACHE 20 and the application insert's the 21'th row - is Oracle then reloading the sequence-cache every 20'th row from disk? In this case, isn't it a problem if the cache is smaller than the number of inserted rows?

Thanks,

Volker Received on Wed Oct 30 2002 - 10:17:45 CST