Loading ...
Sorry, an error occurred while loading the content.

Re: PeopleSoft DBA Forum METHOD_OPT - for gathering Hisograms on columns

Expand Messages
  • babaliviu
    Hi Vasudevan, Although pretty general, some information in this regard can be found also in the PDF attached in the DocID 656639.1 : PeopleSoft Enterprise
    Message 1 of 4 , Oct 2, 2009
    • 0 Attachment
      Hi Vasudevan,

      Although pretty general, some information in this regard can be found also in the PDF attached in the DocID 656639.1 :
      "PeopleSoft Enterprise Performance on Oracle 10g Database "

      Regards,
      Liviu

      --- In psftdba@yahoogroups.com, "Vasudevan" <vjkidambi@...> wrote:
      >
      > Willem,
      > I have not jumped into any conclusion. I was just wondering whether anybody had any thoughts on this and I am grateful for your response.
      > Peoplesoft is a software that is not written by us. Therefore I thoght of asking people in this forum whether there is a general rule that needs to be followed with respect to 'METHOD_OPT' for oracle 10g.
      > If you feel that this depends on an installation, I appreciate your response and work on resolving our issue.
      >
      > Thanks once again
      >
      > --- In psftdba@yahoogroups.com, <Willem.Leenen@> wrote:
      > >
      > > Hello Vasudevan,
      > >
      > >
      > >
      > > So you read about a specific setting and wondered if that could be the
      > > answer to your problem. Such approach is only valid when you are unable
      > > to properly analyze the problem. Just trying and see what happens may
      > > lead to a waste of time, and you may not learn anything out of that.
      > > From your email it isn't clear to what extend you were able to analyze
      > > the problem or what else you have tried. Have you any reasons to believe
      > > that bind variable peeking is indeed the problem?
      > >
      > >
      > >
      > > If not, then my recommendation is to first concentrate on identifying
      > > the problem before you think about solutions. For application tuning,
      > > run a 10046 trace of the identified problem and see if you can reproduce
      > > the problem at hand. That would be a first start...
      > >
      > >
      > >
      > > Regards,
      > >
      > > Willem Leenen
      > >
      > >
      > >
      > >
      > >
      > >
      > >
      > >
      > >
      > > ________________________________
      > >
      > > From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com] On Behalf
      > > Of Vasudevan
      > > Sent: woensdag 23 september 2009 14:38
      > > To: psftdba@yahoogroups.com
      > > Subject: PeopleSoft DBA Forum METHOD_OPT - for gathering Hisograms on
      > > columns
      > >
      > >
      > >
      > >
      > >
      > > I am using ORACLE 10.2.0.3 (32-bit) and 10.2.0.4 (64-bit) on Windows.
      > > The peoplesoft version is 8.9.
      > >
      > > I have not changed the default 'FOR ALL COLUMNS SIZE AUTO'. I am reading
      > > articles about how this can affect performance espicially with 'Bind
      > > variable peeking'.
      > >
      > > I plan to change it to 'FOR ALL COLUMNS SIZE 1', test and build
      > > histograms for colums in specific tables where the data might be skewed.
      > >
      > > Does anyone have any thoughts on this?
      > >
      > > I am trying to improve the performance of certain Peoplesoft functions
      > > like 'Pay Cycle'.
      > >
      > > Thanks,
      > >
      > >
      > >
      > > -----------------------------------------------------------------
      > > ATTENTION:
      > > The information in this electronic mail message is private and
      > > confidential, and only intended for the addressee. Should you
      > > receive this message by mistake, you are hereby notified that
      > > any disclosure, reproduction, distribution or use of this
      > > message is strictly prohibited. Please inform the sender by
      > > reply transmission and delete the message without copying or
      > > opening it.
      > >
      > > Messages and attachments are scanned for all viruses known.
      > > If this message contains password-protected attachments, the
      > > files have NOT been scanned for viruses by the ING mail domain.
      > > Always scan attachments before opening them.
      > > -----------------------------------------------------------------
      > >
      >
    Your message has been successfully submitted and would be delivered to recipients shortly.