Home » RDBMS Server » Performance Tuning » working with tkprof utility (oracle 10g)
working with tkprof utility [message #383587] Thu, 29 January 2009 04:07 Go to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
how to work with tkprof utility for sql performance tuning.how to
proceed with it.also give working steps for statspack utility too
Re: working with tkprof utility [message #383590 is a reply to message #383587] Thu, 29 January 2009 04:12 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you read the documentation?
Re: working with tkprof utility [message #383591 is a reply to message #383590] Thu, 29 January 2009 04:15 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
the command to proceed for finding the trace file with tkprof is
tkprof input.trc output.prf [options]
example is given like
$ tkprof orcl102_ora_3064.trc output.prf EXPLAIN=scott/tiger SYS=NO

suggest me for input.trc what i have to proceed

[Updated on: Thu, 29 January 2009 04:36]

Report message to a moderator

Re: working with tkprof utility [message #383597 is a reply to message #383591] Thu, 29 January 2009 04:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Activate a SQL trace.
Before you ask how, reread Littlefoot's answer and maybe search in the forum.

Regards
Michel
Re: working with tkprof utility [message #383599 is a reply to message #383597] Thu, 29 January 2009 04:47 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
can you tell me where exactly the trace files will reside
Re: working with tkprof utility [message #383602 is a reply to message #383599] Thu, 29 January 2009 05:08 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"user_dump_dest" directory.

Regards
Michel
Previous Topic: Hash cluster with small (tiny) rows ?
Next Topic: Materialized View Vs Table functions
Goto Forum:
  


Current Time: Tue Dec 06 14:08:41 CST 2016

Total time taken to generate the page: 0.14952 seconds