plan_table changes

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

Advertisements

3 Responses to “plan_table changes”

  1. mdinh Says:

    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:

    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:

    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

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: