Home » RDBMS Server » Performance Tuning » I don't get Rows & Row Source Operation
icon9.gif  I don't get Rows & Row Source Operation [message #132085] Wed, 10 August 2005 15:13 Go to next message
perfnewbee
Messages: 2
Registered: August 2005
Junior Member
Hi,

I'm generating trace file by setting sql_trace to true. This creates a trc file and by using the tkprof utility i generate a text file. I'm trying to get the Rows & Row Source operation info for a certain query. The frustrating part is that the trace file collects this information for some queries and not for the query that i'm interested in.

Is there a reason why the trace file collects this information for some queries and not for others?

It would be great if someone can help me with this

EX: The following information is missing for the query
Rows Row Source Operation
------- ---------------------------------------------------
0 NESTED LOOPS (cr=3 r=1 w=0 time=364 us)
0 NESTED LOOPS (cr=3 r=1 w=0 time=355 us)
0 TABLE ACCESS FULL ASSOCIATION$ (cr=3 r=1 w=0 time=346 us)
0 TABLE ACCESS BY INDEX ROWID OBJ$
0 INDEX UNIQUE SCAN I_OBJ1 (object id 36)
0 TABLE ACCESS CLUSTER USER$
0 INDEX UNIQUE SCAN I_USER# (object id 11)

Thanks a bunch!

Re: I don't get Rows & Row Source Operation [message #132086 is a reply to message #132085] Wed, 10 August 2005 15:40 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10702
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
what is your trace level?
use a level 8 ( TO get the Bind information use level 12)

sql> alter session set events '10046 trace name context forever, level 8';

and tkprof has some bugs.
Did you try with trace analyzer?
Re: I don't get Rows & Row Source Operation [message #132088 is a reply to message #132086] Wed, 10 August 2005 15:44 Go to previous messageGo to next message
perfnewbee
Messages: 2
Registered: August 2005
Junior Member
Hi,

I have the bind information as the trace level is set with binds and waits.
I haven't tried with trace analyzer, where i can find more information on using that?

Thanks again!
Re: I don't get Rows & Row Source Operation [message #132089 is a reply to message #132088] Wed, 10 August 2005 15:49 Go to previous message
Mahesh Rajendran
Messages: 10702
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
metalink.oracle.com

tkprof will not show bind information.
Look into trace analyzer.

[Updated on: Wed, 10 August 2005 15:55]

Report message to a moderator

Previous Topic: Solaris 7 Oracle 8.1.6 logfile switch takes 10 minutes
Next Topic: All sorting etc done on temp space
Goto Forum:
  


Current Time: Fri May 27 17:38:06 CDT 2022