ChinaUnix.net
相关文章推荐:

License high water mark 400

high water mark 如果很高,会影响全表扫描的sql的效率,但是否会影响 [code]select * from table1 where rownum < 100[/code]这样的sql的效率呢?为什么?

by HappyWin - Oracle - 2005-05-24 10:29:09 阅读(1217) 回复(6)

相关讨论

I wish to know what is high water mark? how can view it? What the impact to have high water mark? Please Advise

by toms1981 - DB2 - 2004-10-10 16:32:20 阅读(1762) 回复(6)

关数据库时,alert_log提示: Shutting down instance (abort) license high water mark = 85 Instance terminated by USER, pid = 6724 其中license high water mark = 85是什么意思

by spvq - Oracle - 2005-01-28 10:39:01 阅读(2891) 回复(2)

high-water mark和low-water mark的作用是什么呀???

by tryhard - AIX - 2007-01-05 15:19:59 阅读(1839) 回复(0)

书中说: truncate table order reuse storage 可以keep the storage,remove all rows,reset the high-water mark,and commit the change 请问其中的high-water mark是什么意思??

by a9711 - Oracle - 2003-06-29 13:19:49 阅读(1552) 回复(4)

请问:high-water mark是什么东西?有什么用处?

by songdu - Oracle - 2003-02-11 14:34:34 阅读(1274) 回复(3)

在DB2 V7.x版本中,如果数据库文件原大小为22G,做过数据清理且做过reorg后为14G。 此时,使用db2 list tablespaces show detail命令查看表空间的大小,显示如下: Tablespace ID = 2 Name = USERSPACE1 Type = Database managed space Contents = Any data State = 0x0000 Detailed explanation: Normal Total pages = 6455296 Useable pages = 6455232 Used pages = 3336096 Free pages = 3119136 high water mark (pages) = 5...

by wang_ghui - DB2 - 2004-03-17 11:27:37 阅读(2009) 回复(4)

reorg及runstats后high water mark参数不降的原因是什么? 哪位有比较好的方法把这个参数值降下来? :lol: :lol: :lol: :lol:

by 007linxx - DB2 - 2004-07-08 15:30:58 阅读(4458) 回复(12)

*硬件型号是决定OS/400 LIC是否需要按处理器付费的因素 825, 870, new 890 需要按处理器个数付OS/400 LIC 其他型号的机器还保持原来的按机器收费的原则 *基本报价中包括Standard and Enterprise Packages中默认处理器个数对应的OS/400 licenses 费用 *license 管理支持 Software license Manager/400 (SLM/400) * OS/400 licenses 必须与硬件对应

by 居士 - AS400 - 2004-05-14 15:01:44 阅读(1266) 回复(2)

我们的400机器一开机就显示以下的提示信息 : OS/400 license Information system serieal number-------------------------------103na3m processor group ................................................p05 No OS/400 licenses are available at this time,if you have a license key to increase the number of OS/400 license ,you may do so now by pressing the F4 key. O...

by mikewytao - AS400 - 2008-08-06 13:20:14 阅读(1662) 回复(4)

我公司有一台as400 有永久码,但是码丢了,现在机器又重新格式化了,我该怎么办?找回原来的key。可以找ibm?

by zhangyj - AS400 - 2008-06-06 14:31:19 阅读(2312) 回复(2)