Re: Global Temp Tables - lots of redo in 9i, why? how to fix?

"DA Morgan" <damorgan_at_exesolutions.com> wrote in message news:3E60D15D.AE267AC2_at_exesolutions.com...

> Plan table is not a GTT or even a temporary table. Check out utlxplan.sql
in
> rdbms/admin.
>

I know, that's why I added global temporary between create and table.

:-)

In the end I don't need to preserve the results of explain plan over time, so it comes in handy this 'autocleaning' feature of GTT.

Bye,
Flavio Received on Sun Mar 02 2003 - 05:12:50 CST