This is a new feature. You can store execution paths which have proven to be
efficient as a so-called 'outline' Doing so you can override any future
decisions of the optimizer.
The outlines are stored in the user OUTLN's tables.
Hth,
Sybrand Bakker, Oracle DBA
"Calvin Crumrine" <Calvin_Crumrine_at_dced.state.ak.us> wrote in message
news:3A8AD21B.D48C27ED_at_dced.state.ak.us...
> We've had our 1st Oracle DB up on 7.3.2 for a little over a year now &
> I'm moving it to a new server running 8.1.5. I've set it up, run the
> catalog scripts, connected, set up a few users, created the tables, etc.
> No problem, but when I listed all the users I found a user OUTLN that I
> didn't (consciously) set up. I won't guarantee it wasn't from running a
> script with a typo in it, but if so I'm not aware of it. I know that
> several 'users' are set up automatically & they are all there (SYS,
> SYSTEM, and DBSNMP) but I've never heard of this one before. Anybody
> have any info on it?
>
Received on Wed Feb 14 2001 - 13:28:58 CST