Hello All, We've just moved our PeopleSoft system to a different server (same model as our old one, but now using an EMC SAN) and we're getting app server and ...
When the PSAPPSRV 'gets stuck' is the process crashing and being restarted or does the same process continue? In Tuxedo 8.1 the number of services and the load...
We're on Tux 6.5 and running a test SQR updates the Load Done from 32400 to 33200 on one of the PSAPPSRV processes. From the Tux logs, it looks like they were...
It sounds more like you have a general performance issue - you've moved the database to a SAN and often this leads to a tuning requirement. I've just been...
Creating a REN server is easy,and requires no additional servers (acveat later). You just go into the application server, give it an open port number and the...
I wouldn't use recycle count = 0 or you'll end up with the stupid app servers growing until they suck up ever available bit of RAM, and then you sometimes have...
Yes I agree with you. Recycle count shouldn't be 0 But our App. Serv (PT 8.43.16) had many crash dumps, hangs ; Recycle count=0 was the only "quick" way to...
There's no reason why you shoudn't use a recycle count of 0 if you know the load and have sized accordingly - just bounce your app servers every night to...
But if you recycle the domain every day then you are saying that you can't leave PSAPPSRV processes running indefinitely. Although perhaps you could afford to...
The recycle count of 1000 is already fairly low, no point in decreasing it further. If the only change to the system was the addition of a SAN and if...
Select * from PSLANGUAGES. Robert Ellis PSE Data Security GmbH <http://www.psedatasecurity.com/> http://www.psedatasecurity.com _____ From: rnaidu73...
I working on tuning paycal in HR8 PT818. Process monitor shows the job ran for 40 minutes. The tkprof of the session shows only 18 minutes spent by Oracle...
Very Probably! When you use SQL TRace enable the wait events (use event 10046, but at level 8). Then look at the events in tkprof (waits=yes) - there are...
Hello, I am able to configure PSOL (PeopleSoft Online Library) successfully. While I am using the Search tab. I am getting the following error. It’s not...
Thanks Dave, I'm looking at paritioning but I struggle with the reasoning behind it. For example my 10046 shows my longest running SQL statement to be 3...
Part of the reasoning is that cobol isn't multithreaded but we can help by running a number of 'smaller' cobols relating to the number of cpu's available....
Its probably easier to explain what happens when you don't use partitioning. You will get multiple processes inserting into and same database blocks at the...
Hey all. Due to the fact that we have loose, un-enforced policies and clueless l-users on our production peoplesoft system, most of whom are outside the US,...
here it is. I am testing this on a moderate payroll which normally runs in 40 mins. I'm hoping any success made here ripples to the other payrolls some of...
You could do something with an Oracle trigger that uses the delivered getpsoprid function (getpsoprid.sql) e.g. get the os user and machine and check it...
Thanks, So the Cobol execution is not the largest part of the response (over 155 seconds), it is actually physical read from disk (491 seconds). call count...
What kind of trigger? The PSAPPSRV sessions do not log in for every service. regards _________________________ David Kurtz Go-Faster Consultancy Ltd. tel: +44...
Indeed not, but doesn't LASTSIGNONDTTM on PSOPRDEFN gets updated every time a user signs in so an update trigger there could be a starting point? Robert Ellis...
Ahh! I had forgotten about that. And 2 lines of trace later it inserts user name and IP address into PSACCESSLOG. PSAPPSRV.2736 1-489 21.31.49 0.000...
Even better, now how do we kick out the additional OPRID session that originates from a different IP - I think we'd need a table of valid OPRID IP combinations...
Kicking a user out and displaying an explanatory message may not be that difficult. I haven't prototyped this, but assuming you are using sign-on PeopleCode, ...
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.
