Home » RDBMS Server » Server Utilities » tkprof - not generating output
tkprof - not generating output [message #230840] Fri, 13 April 2007 01:22 Go to next message
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.
Re: tkprof - not generating output [message #230852 is a reply to message #230840] Fri, 13 April 2007 02:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: tkprof - not generating output [message #230854 is a reply to message #230840] Fri, 13 April 2007 02:09 Go to previous messageGo to next message
rleishman
Messages: 3724
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.
Re: tkprof - not generating output [message #230875 is a reply to message #230854] Fri, 13 April 2007 02:52 Go to previous messageGo to next message
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.
Re: tkprof - not generating output [message #230884 is a reply to message #230875] Fri, 13 April 2007 03:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: tkprof - not generating output [message #230887 is a reply to message #230884] Fri, 13 April 2007 03:58 Go to previous messageGo to next message
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.
Re: tkprof - not generating output [message #230892 is a reply to message #230887] Fri, 13 April 2007 04:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is available for everyone.
Use man (command depends on OS).

Regards
Michel

Re: tkprof - not generating output [message #230896 is a reply to message #230892] Fri, 13 April 2007 04:25 Go to previous messageGo to next message
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.
Re: tkprof - not generating output [message #230899 is a reply to message #230896] Fri, 13 April 2007 04:39 Go to previous messageGo to next message
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 224 times)
Re: tkprof - not generating output [message #230902 is a reply to message #230896] Fri, 13 April 2007 04:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: tkprof - not generating output [message #230905 is a reply to message #230902] Fri, 13 April 2007 05:07 Go to previous messageGo to next message
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.
Re: tkprof - not generating output [message #230929 is a reply to message #230905] Fri, 13 April 2007 07:13 Go to previous message
Michel Cadot
Messages: 64103
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
Previous Topic: public synonyms are not getting imported
Next Topic: Invalid Number Error in sql loader
Goto Forum:
  


Current Time: Sun Dec 04 04:13:42 CST 2016

Total time taken to generate the page: 0.07978 seconds