Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: What is user 'OUTLN'?

Re: What is user 'OUTLN'?

From: Calvin Crumrine <Calvin_Crumrine_at_dced.state.ak.us>
Date: Wed, 14 Feb 2001 14:25:31 -0900
Message-ID: <3A8B13EB.F9938F9@dced.state.ak.us>

Thanks.

Sybrand Bakker wrote:

> 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 - 17:25:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US