You are not making any sense. With cursor_sharing=exact, Oracle is NOT replacing literals with bind variable, only with cursor_sharing=force or similar. Also,...
After finding some major performance problems with some of the delivered Psoft views, we did some investigation. Peoplesoft may use bind variables alot, but...
Although the cursor sharing discussion has moved on a bit, I like to clarify a point made at the beginning. PeopleSoft generally uses bind variables in i) code...
David, Thanks for the great explanation. This will definitely help a bunch. Also, I just purchased your book and it is great resource. Thanks David Kurtz...
Hi All, Happy New Year. Our Environment: We have Finance8.4 SP1 (Tools 8.43.16), HCM 8.8 (Tools 8.42.20) and Portal8.4 (Tools 8.43.16) Peoplesoft databases are...
My experience suggests that there is no way to get an exact number. First, the database won't give you an accurate number because end-user client connections...
From PT8.44 you can use the performance monitor. Event 150 will provide JVM statistics, including the number of JVM threads. If you have mutliple JVMs you will...
David Kurtz
david.kurtz@...
Jan 4, 2005 11:11 pm
812
My Thought process goes some thing like this. 1) At Web Server level (Portal Web Server or Application Web Server) once the validation is done with LDAP the...
In addition to what David has said, you also need to take into account the concurrent connections you have from your process scheduler/s. This may or may not...
Hi, I have some headache with these process PSPUBDSP eating all the CPU and the process PSPUBDSP is always busy with this service "PSPUBDSP_dflt" and there's...
What PeopleTools release are you using? There are some reports on Customer Connection that describe problems with this server. In particular see GSC Solution...
Hi, What is meant by Peoplesoft DBA. I am an Oracle DBA and intrested in gaining aditional skills. Some one please tell me what is Peoplesoft DBA in detail... ...
David, thanks for your reply. I use Peopletools HRMS 8.19 Still investigating. I disabled the Pub/Sub servers and now i see some new messages for USER_PROFILE...
As far as I recall these are messasge that PeopleSoft send automatically to syncrhonize users and roles across different PS product installations, e.g. to sync...
Hello! You want to look at the what the PSPUBDSP is doing in terms of activities. All indications point to some activity that is taking a long time and...
Hello! A PeopleSoft DBA is essentially a DBA (oracle, db2, mysql, etc.) who has additional understanding of the PeopleSoft application and architecture and how...
HI All, Please help me in setting up Peoplesoft PIA with IBM websphere 5.1. I am using PT 8.45 with HRMS 8.9 Couple of doubts. 1. Whether th Websphere is...
Hi, to exclude oprids from expiration password you can execute the following sql statement: update psoprdefn set lastpswdchange = '31-Dec-2010' where oprid =...
I know this forum has a global reach, but for those of you in the UK and Ireland, and perhaps some of you in continental Europe, here is a date for your diary....
Good day. I am to write a procedure that does an unattended data load of prod data into test. What I do normally is Copy export file from prod to test Drop all...
Hello, everyone. Does anyone have summary of technical requirement for peopletools 8.44 installation? I know that I need to install COBOL complier, but other...
Reminder from the Calendar of psftdba http://groups.yahoo.com/group/psftdba/cal OakTable Seminar: AskTom Live with Tom Kyte! Tuesday February 8, 2005 9:00 am -...
psftdba@yahoogroups.com
Feb 8, 2005 8:40 am
831
Hi, Do you have an access to Peoplesoft Customer Connection ? All supported plateforms are described by peopletools release .And futhermore, implementation...
If you use a windows platform XP or W2003 then it is possible with SC SC \\SERVER01 START "SERVICE_NAME" SC \\SERVER01 STOP "SERVICE_NAME" SC \\SERVER01 query ...