oracle修改open_cursors,oracle open_cursors

先备份一下 C:\oracle\product\10.2.0\db_2\dbs

SPFILEIDMP.ORA

alter system set open_cursors=600 scope=spfile;

500 ~1000

select a.name, b.value

from v$statname a, v$mystat b

where a.statistic# = b.statistic#

and lower(a.name) like '%' || lower('cursor')||'%'

NAME                                                                  VALUE

---------------------------------------------------------------- ----------

opened cursors cumulative                                               166

opened cursors current                                                    1

session cursor cache hits                                               107

session cursor cache count                                               19

cursor authentications                                                   18

参考

http://hi.baidu.com/xiutuo/blog/item/db64e27e5b72233c0dd7da0a.html

http://blog.chinaunix.net/u2/68465/showart_683669.html

http://lovexueer.itpub.net/post/5072/45405

posted on 2008-06-13 16:25 小高 阅读(904) 评论(1)  编辑  收藏 所属分类: Oracle