查询cache值
select cache_size from user_sequence where sequence_name='XXXX';
修改cache值
alter sequence XXXX cache 2000;
删除语句:
DROP SEQUENCE MYUSER.S_MYSEQUENCE;
create sequence MYUSER.S_MYSEQUENCE
minvalue 1
maxvalue 999999999999999999999999999
start with 1--起始值
increment by 1--增量
cache 20;
看哪些有dba权限
select * from dba_role_privs where granted_role='DBA';