Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Estimate temp space
On Apr 5, 3:29 pm, "astalavista" <nob..._at_nowhere.com> wrote:
> Hi,
>
> Is it possible for query to estimate its temp consumption ?
>
> Thanks in advance
The output from dbms_xplan.display provides just such estimates.
David Fitzjarrell Received on Thu Apr 05 2007 - 15:35:30 CDT