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

Report message to a moderator

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

Report message to a moderator

Previous Topic: Strange Performance Problem
Next Topic: Reverse Key Indexes
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 06:56:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.