-
Hi,
I can see the USED value from DBA_OUTLINES and the DEFAULT value in V$SQL for my OUTLINE, but when I do a trace, I get no indication that the OUTLINE was used at all.
I can see the same explain plan as the outline has, but if i didn't know what the explain plan was for the outline, i wouldnt know from the explain plan that it was being used.
How can I get the OUTLINE infomation to show in my trace, either, set autotrace on or TKPROF?
Thanx
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|