OraFAQ Forum: Server Utilities » tkprof

Home » RDBMS Server » Server Utilities » tkprof - not generating output

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

tkprof - not generating output [message #230840]

Fri, 13 April 2007 01:22

Brayan
Messages: 315
Registered: June 2002

Senior Member

Hi,

I have generated trace for event 10046.

The trace is around 20GB.

Now when I run the following command, tkprof just hangs and never comes out. Also, the output file remains size 0 only.

$ tkprof proddwdb_ora_16597.trc proddwdb_ora_16597.out explain=boidw/xxx

The user is the same user for which generated the trace.

Why this is hanging, is it because the size of trace is very big?

Brayan.

Report message to a moderator

Re: tkprof - not generating output [message #230852 is a reply to message #230840]

Fri, 13 April 2007 02:08

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Remove the "explain" option it will be faster and the option is useless as trace already contains execution plan.

Regards
Michel

Report message to a moderator

Re: tkprof - not generating output [message #230854 is a reply to message #230840]

Fri, 13 April 2007 02:09

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

Try it without the EXPLAIN=boidw/xxx

Modern versions of the RDBMS will actually still produce the plan beacuse it is stored in the trace file. EXPLAIN can sometimes just slow you down.

Report message to a moderator

Re: tkprof - not generating output [message #230875 is a reply to message #230854]

Fri, 13 April 2007 02:52

Brayan
Messages: 315
Registered: June 2002

Senior Member

Hi,

I tried without Explain also. I waited for 30mins, still did not generate output file( I mean size is 0 bytes).

Regards,
Ronald.

Report message to a moderator

Re: tkprof - not generating output [message #230884 is a reply to message #230875]

Fri, 13 April 2007 03:48

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Oracle version?
OS?

Try a tusc/truss to see what your process is doing.

Regards
Michel

Report message to a moderator

Re: tkprof - not generating output [message #230887 is a reply to message #230884]

Fri, 13 April 2007 03:58

Brayan
Messages: 315
Registered: June 2002

Senior Member

Hi,

Oracle Ver - 9.2.0.7
OS - HP-UX B.11.11

Can you please tell me how to use this command. Is it only available for root?

Brayan.

Report message to a moderator

Re: tkprof - not generating output [message #230892 is a reply to message #230887]

Fri, 13 April 2007 04:06

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

It is available for everyone.
Use man (command depends on OS).

Regards
Michel

Report message to a moderator

Re: tkprof - not generating output [message #230896 is a reply to message #230892]

Fri, 13 April 2007 04:25

Brayan
Messages: 315
Registered: June 2002

Senior Member

Hi,

Quote:

Try a tusc/truss to see what your process is doing.

Both these command are not available for me.

Brayan.

Report message to a moderator

Re: tkprof - not generating output [message #230899 is a reply to message #230896]

Fri, 13 April 2007 04:39

Brayan
Messages: 315
Registered: June 2002

Senior Member

Hi,

I have generated the required output from "glance" utility.

As you see in the atatched file, both read/write process are working.
But it it not generating any output.

Brayan.

Attachment: process.log
(Size: 1.62KB, Downloaded 1209 times)

Report message to a moderator

Re: tkprof - not generating output [message #230902 is a reply to message #230896]

Fri, 13 April 2007 04:48

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Ask you SA (system administrator) to know which tool it is for your OS and to allow you to work with it.

Regards
Michel

Report message to a moderator

Re: tkprof - not generating output [message #230905 is a reply to message #230902]

Fri, 13 April 2007 05:07

Brayan
Messages: 315
Registered: June 2002

Senior Member

Hi,

It has finished, It took 4 hrs to generate tkprof output.

Thanks a lot for your suggestions.

Brayan.

Report message to a moderator

Re: tkprof - not generating output [message #230929 is a reply to message #230905]

Fri, 13 April 2007 07:13

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

4 hours to analyze a 20GB trace file, I don't think it is too much.
Just my opinion.

Regards
Michel

Report message to a moderator

Previous Topic:	public synonyms are not getting imported
Next Topic:	Invalid Number Error in sql loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 26 13:53:04 CDT 2024