We're going to need a bit more than that! What program? Which Module/Product? What version?...
4341
Hsieh, Joan
joanhsieh01
Sep 28, 2010 6:22 pm
HI listers, This is the question from our FM tech team. Our FM peoplesoft database has been upgraded from oracle 10.2.0.4 to 11.2.0.1, it impact the Load...
4342
Nicolas Gasparotto
gnom92
Sep 28, 2010 6:37 pm
Hello Joan, I don't know that particular process Load ProCard Stage and how it is currently working (drop+create table ? how is the insert ?), but you could ...
4343
David Kurtz
davidkurtz
Sep 28, 2010 6:40 pm
Is it an INSERT SELECT statement? If so, perhaps it is the query. You are going to need to look at the execution plan, and the ASH data to work out how much...
4344
Hsieh, Joan
joanhsieh01
Sep 28, 2010 6:52 pm
Thanks for your apply, There is just one sql statement as below; no execution plan for this statement. Awa show heavy cpu/IO consumption. Peoplesoft trace...
4345
Nicolas Gasparotto
gnom92
Sep 28, 2010 7:20 pm
Joan, how did you determined this insert was the issue ? How many calls to this statement ? Nicolas....
4346
David Kurtz
davidkurtz
Sep 28, 2010 7:28 pm
The chances are that this is inside some sort of PeopleCode loop (because there are bind variables) Normally I wouldn't expect the database to be responsible...
4347
Graham Bowden
grahambowden@...
Sep 28, 2010 7:29 pm
Very simple statement - therefore thoughts go to: Statement is being run lots of times (as it is an insert of bind variables into a temp table) in a very tight...
4348
srisaro
Sep 29, 2010 9:03 am
Try to reset the PS password or the password of the userid which is used to boot the app server. The userid can be found in psappsrv.cfg file. Remember to use...
4349
srisaravana kumar
srisaro
Sep 29, 2010 9:03 am
Try resetting the pwd for the userid found in psappsrv.cfg file. Remember to use datamover to reset the password. Â --Sri ... From: andrewgrout@......
4350
srisaro
Sep 29, 2010 10:05 am
run stats on the table to which the data is being uploaded....
4351
prasad prasad
prasad_83_2000
Sep 29, 2010 5:00 pm
Please check if the required indexes are on the table , would be better if you post one eg of the query  Regards, Prasad ... From: srisaro...
4352
Devesh Padmanabhan
devesh_mp
Sep 30, 2010 7:32 am
Also check that the DBNAME is correct in the PS.PSDBOWNER table....
4353
Montgomerie, Steve (G...
smontgomerie
Sep 30, 2010 12:22 pm
Start off my reading David's book - Peoplesoft for the Oracle DBA! I have a trigger (taken from David's book) that traces process scheduler jobs with a 10046...
4354
David Kurtz
davidkurtz
Sep 30, 2010 12:29 pm
If there is ever a second edition it will include a chapter on ASH. For now, see http://www.go-faster.co.uk/ukougpres.htm#Practical_ASH.ppt regards ...
4355
Montgomerie, Steve (G...
smontgomerie
Oct 1, 2010 12:33 pm
Great work on this David. Your book should really be shipped with each PS order from Oracle. I hope you do come out with a new edition - Maybe PS that includes...
4356
the dragon
ceprn
Oct 1, 2010 1:16 pm
Fusion? Won't that happen about the same time we get flying cars, human cloning and peace in the middle east? I thought we were supposed to have it already. ...
4357
Nicolas Gasparotto
gnom92
Oct 1, 2010 1:28 pm
However, unless I missed something, Fusion Appl. has been announced for Q1 next year : ...
4358
SP
sripingali
Oct 1, 2010 4:22 pm
We are big PeopleSoft shop and my management looking to procure a job scheduler - Various folks on the project suggested the following so far - as everyone...
4359
indranil chakraborty
indranil06_ibm
Oct 1, 2010 4:50 pm
attachment here attached...can be a good start... Regards Neel ... -- Thanks & Regards Indranil 91-98308336990 " The problem is not that there are...
4360
the dragon
ceprn
Oct 1, 2010 5:06 pm
Heh. In my experience, the only thing that works "perfectly" with peoplesoft is the Process Scheduler. And, if all you are using is PeopleSoft, that should...
4361
Manoj Kumar
nedmanoj
Oct 1, 2010 8:36 pm
Hi David, Â Â Â EPM 9.1 with tools 8.51. Application tools need to be upgraded from 8.50 to 8.51 Â After running rel scripts and CA moved to run the DDLORA...
4362
Nicolas Gasparotto
gnom92
Oct 1, 2010 8:41 pm
Are you on 11g+ ? SYSADM's password in upper case (oracle user and/or in PSACCESSPRFL) ? Nicolas....
4363
the dragon
ceprn
Oct 2, 2010 12:14 am
Have you performed the necessary post refresh steps? Such as changing ps.psdbowner if necessary, as well as changing the sysadm passwords? (because I know...
4364
william_gioioso@...
wjgioioso
Oct 2, 2010 2:28 pm
We use Control M which has a plug-in for PS process scheduler. We've been using it for several years. Product is stable and support is very good. --Bill ... ...
4365
vignesh_258
Oct 2, 2010 6:33 pm
Hi. I have question on PeopleSoft works when you transfer to a PeopleSoft page from an external system by giving the URL. ...
4366
David Kurtz
davidkurtz
Oct 2, 2010 8:31 pm
This SQL looks like it is the query on the component search record. You can't remove the distinct. By default PeopleSoft uses the 'begins with' comparsion and...
4367
SP
sripingali
Oct 3, 2010 6:29 am
The 3rd schdulers attachment really helpful - thanks Neel. Thanks Clark for control-m suggestion - I saw control-M in action but did not used much, at personal...
4368
ANDREW GROUT
andrewgrout...
Oct 11, 2010 8:56 am
All, I am using PS HRMS V8.3, PeopleTools 8.19.01 QA instance that has just been recently refreshed from production. Â When I run process scheduler jobs the...
4369
Montgomerie, Steve (G...
smontgomerie
Oct 11, 2010 10:06 am
Did you restart the process scheduler after the change? Steve Montgomerie Oracle / Peoplesoft / OBI Administrator...
