补充一下sequence对seq$的修改,cache后每产生一定数量的序列值才update一下seq$
SQL> create sequence cached_3
2 start with 1
3 increment by 1
4 maxvalue 1000000000
5 cache 3
6 nocycle;
18:03:46 sys@ORCL>select s.obj#,o.object_name,s.highwater
19:09:39 2 from seq$ s, dba_objects o where s.obj#=o.object_id
19:09:39 3 and o.objECt_name='CACHED_3';
OBJ# OBJECT_NAME HIGHWATER
---------- -------------------------------------------------------------------------------------------------------------------------------- ----------
58725 CACHED_3 10
已选择 1 行。
已用时间: 00: 00: 00.04
19:09:40 sys@ORCL> SELECT CACHED_3.NEXTVAL FROM DUAL;
NEXTVAL
----------
8
已选择 1 行。
已用时间: 00: 00: 00.03
19:09:48 sys@ORCL>/
NEXTVAL
----------
9
已选择 1 行。
已用时间: 00: 00: 00.03
19:09:49 sys@ORCL>/
NEXTVAL
----------
10
已选择 1 行。
已用时间: 00: 00: 00.04
19:09:50 sys@ORCL>select s.obj#,o.object_name,s.highwater
19:09:56 2 from seq$ s, dba_objects o where s.obj#=o.object_id
19:09:56 3 and o.objECt_name='CACHED_3';
OBJ# OBJECT_NAME HIGHWATER
---------- -------------------------------------------------------------------------------------------------------------------------------- ----------
58725 CACHED_3 13
NOcache是对产生一个序列值就修改一次seq$:
SQL> select s.obj#,o.object_name,s.highwater
2 from seq$ s, dba_objects o where s.obj#=o.object_id
3 and o.objECt_name='NO_CACHED';
OBJ# OBJECT_NAME HIGHWATER
---------- -------------------------------------------------------------------------------- ----------
58706 NO_CACHED 100001
SQL> SELECT NO_CACHED.NEXTVAL FROM DUAL;
NEXTVAL
----------
100001
SQL>
SQL> select s.obj#,o.object_name,s.highwater
2 from seq$ s, dba_objects o where s.obj#=o.object_id
3 and o.objECt_name='NO_CACHED';
OBJ# OBJECT_NAME HIGHWATER
---------- -------------------------------------------------------------------------------- ----------
58706 NO_CACHED 100002
SQL> SELECT NO_CACHED.NEXTVAL FROM DUAL;
NEXTVAL
----------
100002
SQL>
SQL> select s.obj#,o.object_name,s.highwater
2 from seq$ s, dba_objects o where s.obj#=o.object_id
3 and o.objECt_name='NO_CACHED';
OBJ# OBJECT_NAME HIGHWATER
---------- -------------------------------------------------------------------------------- ----------
58706 NO_CACHED 100003