Re: please help with stored outlines

Sanity check, did you set this anywhere?

alter session set use_stored_outlines=true;

• Jusung Yang

"Ryan" <rgaffuri_at_cox.net> wrote in message news:<577Ga.12036$Id7.10856_at_news2.east.cox.net>...
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:vehus991ps3u42_at_corp.supernews.com...
> >
> > "Ryan Gaffuri" <rgaffuri_at_cox.net> wrote in message
> > news:1efdad5b.0306121146.aba36b_at_posting.google.com...
> > > This is the first time I have used them.
> > >
> > > I logged is as User A, created an outline based on an update
> > > statement. Check DBA_OUTLINES. Its been created. I gave it a category.
> > >
> > > User B, has its own tablespaces which is a duplicate of the tablespace
> > > that USer A defaults to. I was hoping to be able to use the outline
> > > created by User A, on the tables used by User B, since they have the
> > > same name, indexes etc... Its not using it.
> > >
> > > So I take it that outlines are tablespace based? Can I created an
> > > outline for one tablespace and move it to another tablespace?
> >
> > Outlines are NOT tablespace based, not at all. Evidently User_b is not
> > running statements with identical hash_values. To get identical
> hash_values,
> > statements should be *EXACTLY* the same.
> >
> However its using different copies of the same tables. The tables have the
> same names, they are just owned by a different user and stored in a
> different tablespace. is it possible to use the outline for this purpose?
>
> >
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
> >
> > to reply remove '-verwijderdit' from my e-mail address
> >
> >
Received on Fri Jun 13 2003 - 02:00:13 CDT