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