Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Row source information from PQ session trace

673580Jan 25 2009 — edited Feb 6 2009
Guys,

Is it possible to get row source information from trace files(10046 event) of PQ session? I'm on 10.2.0.4.

I tried using trcsess to consolidate tracefiles of PQ slaves and QC and then run tkprof but not successful. It shows all consolidated call information (e.g. parse, execution, fetch ) but it does not show row source information for each step of execution plan.

I also tried using dbms_xplan.display_cursor after running PQ SQL with "gather_plan_statistics" hint but it just displays the rowsource information for the work done by QC, other steps shows up as all 0s.

Is there any way to consolidate this information (other than writting my own parser... )?

Thanks in advance for your help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 26 2009
Added on Jan 25 2009
#general-database-discussions
6 comments
792 views