 I don't get Rows & Row Source Operation [message #132085] |
Wed, 10 August 2005 15:13  |
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!
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
