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: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 14 Feb 2001 20:28:58 +0100
Message-ID: <t8m1pafa9lnk5f@beta-news.demon.nl>

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

Original text of this message

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