«
»

plan_table changes

By Andrew Fraser

This page has been moved to http://andrewfraserdba.com/?p=43

This entry was posted on Wednesday 23 May 2007 at 3:16 pm and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

3 Responses to “plan_table changes”

  1. mdinh Says:
    Wednesday 23 May 2007 at 9:02 pm

    Another difference from 10g is that plan_table is a real table rather than a global temporary table.

    Don’t you mean that 10g plan_table is global temporary and not real table?

  2. Andrew Fraser Says:
    Thursday 24 May 2007 at 7:44 am

    Thanks, poor choice of wording on my part. Have now changed it to “Another difference from 10g: in 9i and below, plan_table is a real table rather than a global temporary table.” which I hope is clearer.

  3. Todd Says:
    Thursday 24 May 2007 at 7:43 pm

    Thanks Andrew – I did not realize that 10g auto-created the plan table. I just went through and dropped all of our redundant copies across instances.

Leave a Reply

You must be logged in to post a comment.