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

FC wrote:

> "DA Morgan" <damorgan_at_exesolutions.com> wrote in message
> news:3E60075D.592FCF7A_at_exesolutions.com...
> > ...
> > What I'd like to know is what is anyone doing that requires GTTs anyway.
> I've
> > been coding in Oracle for more than a decade and have yet to "need" one.
>
> Not even for the "explain plan" table?
>
> Bye,
> Flavio

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

Daniel Morgan Received on Sat Mar 01 2003 - 09:27:25 CST