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 ...
First, write a small export script to save off the report node information and anything else you want to save. Have a par file that lists those tables - this...
Thank you very much for your information, Laurent. I'm starting to read the documents. I have another question. What is peoplesoft's recommendation for RAID?...
see www.baarf.com - behind the hilarity there is a very serious point being made read James Morle's seminal Sane San paper. Put the database on raid 1+0 (a...
Thank you very much, David. If I make the database on RAID 5 (save space), would this be adequate enough? ... __________________________________ Do you...
Reminder from the Calendar of psftdba http://groups.yahoo.com/group/psftdba/cal OakTable Seminar: AskTom Live with Tom Kyte! Wednesday February 9, 2005 9:00 am...
psftdba@yahoogroups.com
Feb 9, 2005 8:41 am
840
Hello All, I am of the understanding that on Oracle 8.1.7 the order that the tables are listed in the FROM clause of a query will affect it's performance. 2...
Actually, having thought about it, would I be right in saying that the query will run fastest in the following scenario: Say you had a simple select query that...
Definitely on right track BUT you need to have good stats for the CBO to make the right choices. Small tables, you should dbms_stats.gather_table_stats at...
Ross Mohan
rmohanx@...
Feb 9, 2005 4:58 pm
843
Philip, This no longer applies...after version 7, if i recall correctly. Still, a la Jonathan Lewis et al. a bit of testing wouldn't hurt but the FROM...
Ross Mohan
rmohanx@...
Feb 9, 2005 4:59 pm
844
Reminder from the Calendar of psftdba http://groups.yahoo.com/group/psftdba/cal OakTable Seminar: AskTom Live with Tom Kyte! Thursday February 10, 2005 9:00 am...
psftdba@yahoogroups.com
Feb 10, 2005 8:41 am
845
OK guys, Since version 7 Oracle RDBMS's can be run in two modes: (init.ora setting) OPTIMIZER=RULE or COST (or CHOOSE for both) in RULE based; tuning is...
Shaun, Minor correction, if your running PeopleTools 8+ they recommend CBO, but if your running anything earlier they recommend rbo, irrespective of the...
Goulet, Dick
dgoulet@...
Feb 11, 2005 10:14 pm
847
It is worth pointing out that the Rule Based Optimiser is deprecated in Oracle 9i and although still present in Oracle 10g (which BTW is not yet certified by...
It is true that if you use RAID 5 you will need fewer disk devices to produce a filesystem of the same size that RAID 10. However, the problem with RAID 5 is...
Thank you very much, David. I highly appreciate your emails. :) - John ... === message truncated === __________________________________ Do you Yahoo!? Read...
With FSCM 8 SP2 ,PS Tools 8.x ,Oracle 8i ,we use OPTIMIZER_MODE=FIRST_ROWS for the all OLTP sessions and OPTIMIZER_MODE=ALL_ROWS + hints on some setps inside...
I need to create individual user names for several developers so that backend changes can be audited by individuals instead of using the SYSADM id. I want to...
We are in the process of doing test runs to upgrade our Finance from 7.5 (7.62 tools) to 8.8 (8.44.10 tools). The 8.8 databases seem very slow at times. I am...
I have done just that, except instead of using synonyms I create a logon trigger for each developer id which does an alter session set current_schema=sysadm. ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
