Re: Turn of Hints

Well that is the idea, sacrifice poorer performance on the inserts in order to maintain a consistent table size. This is a data collector of sorts. Generally you are going to only run it for a period of a few hours, gather results, drop tables. But in some cases it will be ongoing data collector with a purge, so I want to reuse the space in that circumstance.

Thanks,

This is 9i, have to check if it is available there.

Ethan

On 4/4/06, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
>
> In 10g: alter session/system set "_optimizer_ignore_hints"=true
>
> Just a warning, you might get worse performance without the direct-mode
> inserts.
>
>

--
http://www.freelists.org/webpage/oracle-l