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...
Willem.Leenen@...
Sep 23, 2009 1:35 pm
3904
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...
Hi All, I am facing frequent locking problem with pstreeselnum table. Mostly 3 tier nVision users are having this problem. Here is the query. update...
It sounds like you are running lots of concurrent nVision reports that use dynamic selectors. What version of PeopleTools are you running? I dislike dynamic...
Hi, We have 4 PSNT process schedulers running in 4 different windows machines. Out of them 1 process scheduler has been configured as master process...
If you configure multiple master scheduler processes on a system only one of them is the active master at any one time. If that master dies or is shutdown,...
Hi David, It sounds like you are running lots of concurrent nVision reports that use dynamic selectors. -Yes, we are. What version of PeopleTools are you...
... One PSAPPSRV or PSQRYSRV process can have two connections to the database. The second connection is used to increment counters. The idea is that it is a...
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...
Hi Nixon, If you want a certain process to run on a certain Process Scheduler only you can do that by typing that specific server name in Process Scheduler >...
Hi Liviu/David,  Thank you for the information. Yes. Actually our need was to remove one process scheduler totally from Load balancing. At same time we...
Due to performance issues the Dba team is planning to partition the Peoplesoft large tables.(oracle 10g HRMS 8.8 SP1)  Is there any issues about...
Some non DBA things to consider: -have you exhausted the functional team's options, such as configuration based changes (assuming GP: restricting retro,...
BANKS, Richard
BanksR@...
Oct 11, 2009 2:07 pm
3917
You can partition tables within PeopleSoft applications. Partitioning is a licenced option on the Oracle database. You would not invalidate your PeopleSoft...
Hi, I am looking for some help on cybersource integration with peoplesoft. Please let me know if anyone has done this before. PT 8.49 with financial 9.0 Thanks...
HI All, Â I am looking for some help on below error. Â ORA-00001: unique constraint (SYSADM.PS_PSPRCSPARMS) violated. Â I know it's due to, trying to insert...
Hi All, We recently modified optimizer_feature_enabled=9.2.0 from 8.1.7 after the change the entire database was kind of hung or very slow. We tested the...
Just to update, We are gathering stats using DBMS_STATS (Gather stale) to avoid gathering stats on TEMP tables which we created for few processes. Thanks, ...
Peoplesoft recommends certain init.ora parameters for use with 9i and 10g databases, when performance issues are encountered. check _unnest_subquery This...
Have you computed system stats? ... From: sachin_borikar <sachin_borikar@...> Subject: PeopleSoft DBA Forum Re: PS HR optimizer_feature_enabled issue To:...
We are working on simulating same condition in stage and then try all the possible parameters. Thank You all for your valuable inputs. I will update you all on...
If you have a sample SQL statement that behaves differently in the two environments, then I would suggest generating an event 10053 trace, and working out...
... after the change the entire database was kind of hung or very slow. ... When you are using a different optimizer setting then several SQL statements will...
Willem.Leenen@...
Oct 28, 2009 2:43 pm
3927
Hi all, I would like to use performance monitor to identify some transaction which need some optimizations. Does any one know how to use performance monitor...
If you mean PeopleSoft's performance monitor, here's some research I did for my manager. If you mean someone else's performance monitor product, stop reading...
BANKS, Richard
BanksR@...
Oct 28, 2009 9:50 pm
3929
Comments in-line _____ From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com] On Behalf Of BANKS, Richard Sent: Wednesday, October 28, 2009 9:32 PM To:...
My 2p's worth: Actually, it is installed by default in every PeopleSoft database. It just needs configuring. It may be ok for small setups but introduces too...
Anil, I am not sure in which way you would like to do the integration. Basically there are two ways to do this integration. 1) Using Business Interlink 2)...
The peoplebook for PPM is quite good. The 'Top Components' component will give you a starting point. It reports top cumulative and average application server...