Home » RDBMS Server » Performance Tuning » tkprof
tkprof [message #65174] Mon, 31 May 2004 13:54 Go to next message
Sam
Messages: 255
Registered: April 2000
Senior Member
do we need to have a plan_table in order to use tkprof utility? thanx in advance
Re: tkprof [message #65175 is a reply to message #65174] Mon, 31 May 2004 14:10 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
No, it will create it in the schema you specify and then drop it afterwards. You can also just leave out the explain=scott/tiger@orcl but then it won't be much use for performance tuning (if you want it for that).

tkprof help=y
Previous Topic: Strange Performance Problem
Next Topic: Reverse Key Indexes
Goto Forum:
  


Current Time: Tue Feb 27 10:04:58 CST 2024