I'm a bit new to the DBA world and my question involves the use of TKPROF. In attempting to use TKPROF on an 8.1.6 database running on 2000, I get an error that my alert file is unable to open. I don't know if this error is do to a syntax problem or the OS installion of TKPROF. Any help that you can provide me with will be greatly appreciated.
Thanks in Advance
Mind like water.
I have never seen TKPROF used with the alert log, but mostly with the trace files. You can try this
tkprof ora_12345.trc trace.txt
There are other options like EXPLAIN too.
OCP DBA 8i, 9i, 10g
Click Here to Expand Forum to Full Width