No, as long as you have the available bandwidth on the server, it works fine - you just need to give them different names. If one is calle PSUNX, you need to...
We have multiple PSUNXs on the same box (and PSNTs as well). They just point at different environments. You do have to be careful about mixing Tools versions...
True, you can have multiple psocess schedulers pointing to different environments. I took the question to mean two different process schedulers for the same...
Hi, Here are the guidelines for number of PSAPPSRV process CRM and HRMS use about 100-150 MB per app server process. CRM gets 50 users per process. HRMS gets...
Two questions 1) Are you trying to install this on Unix or Windows - it makes a big difference to the ease of setting it up 2) Do you mean setting up two...
Can you have two process schedulers and allow only some users access to one of them? For example, two process schedulers - one on the same db making a bequeath...
Mongoose!!!!! You can, but there are some gotchas - most specifically, ps jobs.. You have to set up the process definitions to default to the server you want...
PeopleSoft DBA ForumHi all, How can one map the PRCSINSTANCE from the PSPRCSRQST table to Oracle session (v$session)? The situation is that the Application...
You can enable trace with a trigger on PSPRCSRQST, control which programs with the when clause. Thus: CREATE OR REPLACE TRIGGER sysadm.set_trace BEFORE UPDATE...
Yes you can do with small customisation (mostly peoplecode). So that users can see their assigned process schduler as default. Sri ... PeopleSoft DBA Forum...
Hi, Thanks. What is correct way to gather statistics now? I was considering using cursor_sharing, so I am glad you mentioned that. Regards, Roberto. Shaun...
hi We are going live with Oracle 10.2.0.2 for PeopleTools 8.47. Besides the below points, Oracle has recommended using dbms_stats.gather_table_stats to gather...
Oracle recommended to us: gather_schema_stats (with both EMPTY and STALE runs). gather_disctionary_stats and gather_system_stats occasionally (weekly). but...
Hi The liscence which we have for our financial system has all the modules enabled .ie: we have liscence for all the modules.i need to setup an environment...
hi all.. may be this may silly question .. but im confusing with this for a long time.. why we have to clearing appserver cache manually.. with regards KCS...
Hi Keith, I am sorry to say tht I donnt have any info how to apply this as we r not using this DBStatistics. However, cud u plz tell me why do you need to run...
You don't have to do it manually, you can write scripts to do it. We do it when we do it, however, to clean out corrupt or incorrect files. When the...
I would like to suggest that we keep communications on this forum professional and have the courtesy and respect to take the time and make the (extra) effort...
Keith, This SQL will generate calls to PLSQL routine to update your statistics - one invocation per schema in the database. Works fine for both 9i and 10g ...
Hi David, Can you let me know how we can get your book 'PeopleSoft for the Oracle DBA ' in India. Is there any other name for this book. On ebay I say the book...
Brutus and Caesar: what should be in that 'Caesar'? Why should that name be sounded more than yours? Write them together, yours is as fair a name; Sound them,...
Sanjay, Go to this this URL http://www.apress.com/book/bookDisplay.html?bID=366 and you can buy the book online either an ebook for immediate download or as a...
I believe it *should* be the same thing as <PS_HOME>/appserv/<domain_name> ... peace, clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary,...