Home » SQL & PL/SQL » Client Tools » Generating tkprof from SqlDeveloper tool. (Oracle 10g)
Generating tkprof from SqlDeveloper tool. [message #584065] Wed, 08 May 2013 08:45 Go to next message
sss111ind
Messages: 563
Registered: April 2012
Location: India
Senior Member

Hi All,

How do i get tkprof trace file in sqldeveloper tool ? I donot have access sql in command mode.

Regards,
Nathan
Re: Generating tkprof from SqlDeveloper tool. [message #584072 is a reply to message #584065] Wed, 08 May 2013 09:14 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
trace files reside on on DB Server.
Can you directly log onto DB Server?

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: Generating tkprof from SqlDeveloper tool. [message #584081 is a reply to message #584072] Wed, 08 May 2013 09:29 Go to previous messageGo to next message
sss111ind
Messages: 563
Registered: April 2012
Location: India
Senior Member

Yes I donot have access to server.

There are few option is there to finetune.
1.explain plan
2.autotrace
3.sql advisor

And I think that is not enough for tuning the queries in sqldeveloper tool.


Regards,
Nathan

[Updated on: Wed, 08 May 2013 09:31]

Report message to a moderator

Re: Generating tkprof from SqlDeveloper tool. [message #584083 is a reply to message #584081] Wed, 08 May 2013 09:34 Go to previous messageGo to next message
Roachcoach
Messages: 1421
Registered: May 2010
Location: UK
Senior Member
Try sql developers sql monitoring functions...they're going to give you most of what a 10046 will give you in terms of typical tuning in my experience.

Edit: Requires tuning pack though...

[Updated on: Wed, 08 May 2013 09:39]

Report message to a moderator

Re: Generating tkprof from SqlDeveloper tool. [message #584133 is a reply to message #584083] Thu, 09 May 2013 00:53 Go to previous messageGo to next message
sss111ind
Messages: 563
Registered: April 2012
Location: India
Senior Member

Hi RoachCoach,

I tried for the option Tools->Monitor SQL....

But it suggests that the database version should be Oracle 11g. But my dbversion is Oracle 10g.So I am unable to use it.

Any suggestion apart from that.

Re: Generating tkprof from SqlDeveloper tool. [message #584136 is a reply to message #584133] Thu, 09 May 2013 01:37 Go to previous message
Roachcoach
Messages: 1421
Registered: May 2010
Location: UK
Senior Member
Oh apologies, I forgot the sqlmon is 11g only Sad
Previous Topic: ORA-12505 TNS:listener does not currently know of SID given in connect descriptor
Next Topic: how to add value from sqlplus
Goto Forum:
  


Current Time: Sat Dec 03 09:54:14 CST 2016

Total time taken to generate the page: 0.05909 seconds