By default, when a sequence is defined, if the options "cache" or "nocache" is specified, Oracle will cache 20 sequence numbers. Usually that will be fine for most of circumstances. However you may see sometimes the following query running slow when getting the next value: select sequence_test.nextval from dual; It could take dozens of seconds … Continue reading select sequence NEXTVAL slow? →