Hi there, I have seen this on almost every Unix server I have ever run PSoft on. For some reason, bringing the servers down, even cleanly, creates a core...
David, What interval and length of run would work best for you? Also, what info would you like for the specifications of DB and App server? Henry ... Technical...
I am looking for enough data to show that the Ping has stabilised. So about 30-60 pings on a 1 minute cycle. I am interested in CPU specification on the App...
David Kurtz
info@...
Jun 1, 2004 10:15 pm
561
A company by the name of e-dba (www.e-dba.com), has a monitoring suite. They are really an Oracle database monitoring and support company, but they have a...
Info for the group: Peoplesoft have backported the PSPing to Tools 8.1 (we're on 8.20 and it seems to work fine). David, this may be abit late for tomorrow (in...
Clark, As with 99% of the applications out in the field poor SQL is 100% of the problem. The bad part is that you don't know where the problem will be worst...
Goulet, Dick
dgoulet@...
Jun 3, 2004 9:54 pm
564
I believe its crusial to know what your companyplans are for the year and what users are doing to the application to make these plans come true (like plans for...
So who writes this code anyway? I'm having a fun problem with NVision, though it's probably not endimic to NVision. When we are running a ReportBook (or report...
Hi, I am getting Error when i am executing dump through suinstall. i am getting the following error. Loading Single User .... 'OSQL' is not recognized as an...
I'm not sure why we've never run across this. Maybe there's just enough lag time between the nVision process' select/insert/commit and the Distribution...
I am running HR 8.8 & Tools 8.43. I am changing the passwords for the Oracle ID's in production to be different than those in development & test. After I...
James, How is stuff going? Change buildings yet? The statuses (stati?) we are getting are either "Success" or "No Success", but I haven't yet confirmed how...
Hi, I have a customer that just went live on Financials 8.4 sp1 with tools 8.43.10 All delivered crystal runs fine. Any custom or modified crystals run fine...
... Maybe these instructions that I found on Customer Connection (below) can help. I use method 1. Cheers, Phillip Eaton Business Applications Administration...
One only changes the PeopleSoft owner's password via PeopleTools. Recommendation, change it back to what it was originally & then use PeopleTools to change it...
Goulet, Dick
dgoulet@...
Jun 11, 2004 9:49 am
573
Hi, Before doing this u just take abackup of PSACCESSPRFL table and then start these steps. To change the access password, u need to do the following steps: 1)...
I also recomment to always change passwords with the PeopleTools of your PeopleSoft database but that's not the question... You can (in PeopleSoft 7.6) see...
Hi, We are currently encountering the same problem periodically. We have not been able to get help from peoplesoft as well. Their support is a joke anyways. We...
As far as I recall the -noclassgc is a java JVM parameter. Garbage collection algorithms and approaches have been much improved in recent JVMs, so you really...
I have used the Method#3 without any issues. I didn't have to do anything at the database level as we are using PT 8.44 -Chenna ... the ... development & ... ...
Do not waste your time. You cannot do much. I am running Web Sphere and Web Logic on AIX j_o__j_o@... wrote:As far as I recall the -noclassgc is a java...
We are running Oracle 817 with the optimizer mode set to choose. I am trying to get accurate statistics for the temp tables that Peoplesoft uses for various...
Its really tough to get statistics on those tables. As you said they will be wiped out as soon as the process completes. But most of the processes have...
If you know the size of the table you can always tell Oracle the statistics in advance using dbms_stats.set_table_stats Henry ... am ... Peoplesoft ... deletes...
For 817, I think we need to put 'analyze' command inside program and right before join. If it is in Oracle 9i, it will be easier since we can use dynamic ...
It is always possible to set the statistics for these temp tables independently. As correctly noted, a compute stats will only record zero rows for temp...
I see that this topic has touched a nerve - there were 4 new messages just while I was writting this. For clarity, we are talking about permanent database...
David Kurtz
info@...
Jun 16, 2004 3:24 pm
586
We had exactly the same problem with Oracle817 / PeopleSoft 7.53. We came up with two possible ways of tackling it. 1. Capture the statistics for the temporary...
I appreciate all the quick responses. This is a great group. I had a few more questions regarding this topic. If peoplesoft is generating the statistics...