ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 'tkprof' is not recognized as an internal or external command

'tkprof' is not recognized as an internal or external command

原创 Linux操作系统 作者:jlandzpa 时间:2019-07-09 11:57:08 0 删除 编辑
实验环境:

winxp + Oracle 9.0.1

实验过程



SQL> show parameter timed_statistics

NAME TYPE VALUE
------------------------------------ ----------- ------
timed_statistics boolean TRUE

SQL> alter session set sql_trace=true;

会话已更改。


执行我要测试的SQL

SQL>select * from zrp where msisdn='905310002';
MSISDN AREA U DEAL_DATE
--------- ---- - ----------
905310002 531 1 25-1月 -05

然后到参数uesr_dump_dest对应的目录下,执行

tkprof ora01068.trc test.prf

结果系统提示:

'tkprof' is not recognized as an internal or external command,

from metalink:


TKPROF.EXE was not shipped with 9.0.1 and this was logged as bug# 2007918 9.0.1.1 with Abstract: TKPROF.EXE BBED.EXE WERE NOT SHIPPED, which was fixed in V9.2. So if you have the RDBMS Baseline Release 9.0.1.1.1, apply 9.0.1.2 patchset (ID:1175356 Patchset::2072050) or later as explained in the patch readme file

166926.1 9.0.1.x Oracle Database and Networking Patches for Microsoft Platforms
161549.1 Oracle Database Server and Networking Patches for Microsoft Platforms

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/936/viewspace-60547/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2001-10-12

  • 博文量
    268
  • 访问量
    171512