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: 480
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: 22718
Registered: January 2009
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: 480
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: 1198
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: 480
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: 1198
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 Aug 30 22:08:20 CDT 2014

Total time taken to generate the page: 0.11459 seconds