出错的位置,运行到这里时就退出来了!
-> Statistics identified by '(derived)' come from sources other than SYSSTAT
Statistic Total per Hour
--------------------------------- ------------------ ---------
log switches (derived) 0 .00
-------------------------------------------------------------
, 'D' , size_for_estimate*1024/:def_cache
*
ERROR at line 10:
ORA-01476: divisor is equal to zero
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options
在用spreport.sql时10.1.0.1版会存在这个问题,但在10.1.0.3已做了修正
同时可以在sprepins.sql文件中找到db_cache_size,将db_cache_size替换成__db_cache_size,共有三个地方,即可成功。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9932141/viewspace-677385/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9932141/viewspace-677385/