stored outlines set?
in [Oracle]
|
Prev: Latch / Wait Events
Next: Visit must
From: Mark D Powell on 18 Nov 2009 09:35 On Nov 17, 2:45 pm, Mladen Gogala <n...(a)email.here.invalid> wrote: > On Tue, 17 Nov 2009 09:33:55 -0800, sbrjd wrote: > > How can I determine if "alter system set use_stored_outlines.." has been > > issued? > > > Steven Rosenthal > > databases etc > > Columbia University IT > > I don't think you can. The most comprehensive set of the parameters > resides in X$KSPPI and there is nothing there: > > SQL> select ksppinm from x$ksppi where ksppinm like '%outl%'; > > KSPPINM > -------------------------------------------------------------------------------- > create_stored_outlines > _plan_outline_data > _outline_bitmap_tree > > Elapsed: 00:00:00.16 > SQL> > > Maybe, it can be read if you dump SGA but I don't know how to read Oracle > dumps. > > --http://mgogala.byethost5.com Did you check the value of create_stored_outlines when you set this session parameter? I ask because I wondered why you could not find the parameter value in v$parameter / v$spparameter which I tested. Then I found Oracle note: Session Parameter: USE_STORED_OUTLINES #ID 68642.1 which says the session parameter is not a database parameter. However, the parameter turns on and off generating outlines and create seems like it might be a fit. I just do not have a system I think I can risk testing on right now. HTH -- Mark D Powell --
From: Mark D Powell on 18 Nov 2009 09:40 On Nov 18, 9:35 am, Mark D Powell <Mark.Powe...(a)hp.com> wrote: > On Nov 17, 2:45 pm, Mladen Gogala <n...(a)email.here.invalid> wrote: > > > > > > > On Tue, 17 Nov 2009 09:33:55 -0800, sbrjd wrote: > > > How can I determine if "alter system set use_stored_outlines.." has been > > > issued? > > > > Steven Rosenthal > > > databases etc > > > Columbia University IT > > > I don't think you can. The most comprehensive set of the parameters > > resides in X$KSPPI and there is nothing there: > > > SQL> select ksppinm from x$ksppi where ksppinm like '%outl%'; > > > KSPPINM > > -------------------------------------------------------------------------------- > > create_stored_outlines > > _plan_outline_data > > _outline_bitmap_tree > > > Elapsed: 00:00:00.16 > > SQL> > > > Maybe, it can be read if you dump SGA but I don't know how to read Oracle > > dumps. > > > --http://mgogala.byethost5.com > > Did you check the value of create_stored_outlines when you set this > session parameter? I ask because I wondered why you could not find > the parameter value in v$parameter / v$spparameter which I tested. > Then I found Oracle note: Session Parameter: USE_STORED_OUTLINES #ID > 68642.1 which says the session parameter is not a database parameter. > However, the parameter turns on and off generating outlines and create > seems like it might be a fit. > > I just do not have a system I think I can risk testing on right now. > > HTH -- Mark D Powell --- Hide quoted text - > > - Show quoted text - Withdraw my comments. The create obviously corresponds to ALTER SYSTEM SET CREATE_STORED_OUTLINES = TRUE | FALSE. Reviewing too many Oracle documents too quickly caused a brain fizz. HTH -- Mark D Powell --
From: Mladen Gogala on 18 Nov 2009 11:03
On Wed, 18 Nov 2009 06:40:20 -0800, Mark D Powell wrote: > On Nov 18, 9:35 am, Mark D Powell <Mark.Powe...(a)hp.com> wrote: >> On Nov 17, 2:45 pm, Mladen Gogala <n...(a)email.here.invalid> wrote: >> >> >> >> >> >> > On Tue, 17 Nov 2009 09:33:55 -0800, sbrjd wrote: >> > > How can I determine if "alter system set use_stored_outlines.." has >> > > been issued? >> >> > > Steven Rosenthal >> > > databases etc >> > > Columbia University IT >> >> > I don't think you can. The most comprehensive set of the parameters >> > resides in X$KSPPI and there is nothing there: >> >> > SQL> select ksppinm from x$ksppi where ksppinm like '%outl%'; >> >> > KSPPINM >> > -------------------------------------------------------------------------------- >> > create_stored_outlines >> > _plan_outline_data >> > _outline_bitmap_tree >> >> > Elapsed: 00:00:00.16 >> > SQL> >> >> > Maybe, it can be read if you dump SGA but I don't know how to read >> > Oracle dumps. >> >> > --http://mgogala.byethost5.com >> >> Did you check the value of create_stored_outlines when you set this >> session parameter? I ask because I wondered why you could not find the >> parameter value in v$parameter / v$spparameter which I tested. Then I >> found Oracle note: Session Parameter: USE_STORED_OUTLINES #ID 68642.1 >> which says the session parameter is not a database parameter. However, >> the parameter turns on and off generating outlines and create seems >> like it might be a fit. >> >> I just do not have a system I think I can risk testing on right now. >> >> HTH -- Mark D Powell --- Hide quoted text - >> >> - Show quoted text - > > Withdraw my comments. The create obviously corresponds to ALTER SYSTEM > SET CREATE_STORED_OUTLINES = TRUE | FALSE. Reviewing too many Oracle > documents too quickly caused a brain fizz. > > HTH -- Mark D Powell -- This is a system parameter and should have been present in the V$PARAMETER table. Unfortunately, it's not. -- http://mgogala.byethost5.com |