OraFAQ Forum: Client Tools » Generating tkprof from SqlDeveloper tool.

Home » Other » Client Tools » Generating tkprof from SqlDeveloper tool. (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Generating tkprof from SqlDeveloper tool. [message #584065]

Wed, 08 May 2013 08:45

sss111ind
Messages: 636
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

Report message to a moderator

Re: Generating tkprof from SqlDeveloper tool. [message #584072 is a reply to message #584065]

Wed, 08 May 2013 09:14

BlackSwan
Messages: 26766
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/

Report message to a moderator

Re: Generating tkprof from SqlDeveloper tool. [message #584081 is a reply to message #584072]

Wed, 08 May 2013 09:29

sss111ind
Messages: 636
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

Roachcoach
Messages: 1576
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

sss111ind
Messages: 636
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.

Report message to a moderator

Re: Generating tkprof from SqlDeveloper tool. [message #584136 is a reply to message #584133]

Thu, 09 May 2013 01:37

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

Oh apologies, I forgot the sqlmon is 11g only Sad

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 00:35:40 CST 2024