Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1041228
  • 博文数量: 276
  • 博客积分: 10077
  • 博客等级: 上将
  • 技术积分: 2513
  • 用 户 组: 普通用户
  • 注册时间: 2007-08-24 20:31
文章分类

全部博文(276)

文章存档

2020年(1)

2015年(5)

2012年(2)

2011年(6)

2010年(7)

2009年(224)

2008年(31)

我的朋友

分类: Oracle

2009-06-12 13:28:00

 
select SEQUENCE_OWNER,SEQUENCE_NAME,cache_size from dba_sequences;
alter sequence SCHEMA.SEQ_NAME cache 200;
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
The Number of Entries in the Sequence Cache

When an application accesses a sequence in the sequence cache, the sequence numbers are read quickly. However, if an application accesses a sequence that is not in the cache, then the sequence must be read from disk to the cache before the sequence numbers are used.

If your applications use many sequences concurrently, then your sequence cache might not be large enough to hold all the sequences. In this case, access to sequence numbers might often require disk reads. For fast access to all sequences, be sure your cache has enough entries to hold all the sequences used concurrently by your applications. 

阅读(1114) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~