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

Home -> Community -> Usenet -> c.d.o.server -> Re: PeopleSoft DBA's

Re: PeopleSoft DBA's

From: Mitchell Loren <mloren_at_home.com>
Date: Mon, 21 Jun 1999 23:42:49 GMT
Message-ID: <376ECBDA.F2455F5C@home.com>


Would you mind getting more specific about how and with which views you changed ? Also, have you come across any on-line (or other) guides to PS performance tuning.

Thanks

Juan Carlos wrote:
>
> Technically, PeopleSoft wouldn't support it, although you could argue that a
> simple performance hint to an SQL statement doesn't change the selection
> criterion. Since our on-line works best in cost, and batch in rule, we
> considered adding hints to a bunch of DMS statements called by the COBOL,
> but found that too daunting. The number of on-line search views we changed
> to include cost hints ended up being 8.
Received on Mon Jun 21 1999 - 18:42:49 CDT

Original text of this message

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