There are some long running Queries (via PSQRYSRV) which have already timed out in the Query server. But they are still running within Oracle and use up...
How about not letting the users write or run long running queries??? peace, clark PSA: Salary <> Slavery. If you earn a salary, your employer is renting your ...
Hi Bob/Manoj Thank you very much for your valuble suggestions. We are any way in the process reimplementing HCM 8.9. Happy to know that this will be resolved...
Hello everyone, I am at a client site that has an interesting problem. I and some of the end users have been timed out during our sessions. In my particular...
what about the network timeout settings? peace, clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services...
When you say "timed out" what do you mean? Do you get a page with a timeout message or do you just drop off the edge? The symptoms could be related to load...
I do get a timeout message. I will have to find out about the load balancing, content switch, or the reverse proxy server. I also have not found out the ...
I have the same issues, can't these peoplesoft views be converted to the materialized views? Most of these long running queries are based on views, I think......
In this case, we can't... we are to resolve this particular Query by removing a col from being selected. By doing that, the Query responds reasonably well. But...
I am curious as to whether anyone has implemented or tried to implement Oracle's automatic statistic gathering. I found some documents (Notes 237901.1,...
As many of the tables in PeopleSoft are pretty much static and a large proportion aren't even used a full compute is a bit over the top. I'm not sure if it's...
Hello, You may try looking into the SQLNET.EXPIRE_TIME parameter in the SQLNET.ORA file on the database server. The expiration time represents an interval that...
Hi, We upgraded ps tools from 8.43.17 to 8.46.09, everything working so far except psrun (can be ignored now) and psnt job not posting to the report ...
Joan, this might be your issue.... Upgrading tools wipes out your PeopleTools:Process Scheduler:Servers:Distribution Tab entry Distribution Node Name: HTTP ...
Hi we have a peopletools upgrade from PT845 to PT845.18 .We have a clustered websphere configuration on production . Can anybody tell me how to reconfigure...
Hi Joan, This could be your node password: Goto PeopleTools-Portal-Node definitions, find the "Default Local Node", Make sure Authentication is set to...
I am working at a client who does not have the PS_SERVER_CFG environment variable set up. The question that I have is how to set this up. I am under a bit of...
Hi Tom You should set the PS_SERVER_CFG variable set to $PS_HOME/appserv/prcs/<domain>/psprcs.cfg. This is required if you are running App Engine etc from the ...
Thanks Hari. I am not sure why I didn't think of that. Tom ... __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail...
I have been able to set up perfomance monitoring successfully on our test systems. However, our live configurations sends traffic via a load balancer. In the...
The problem is you should be letting PS play with a Chevy, rather than a Ford... ps_play( ford)$ ps_play( ford)$ ps_play( ford)$ Sorry, couldn't help myself. ...
<Moderator>This is an example of how not to ask a question in a user group!</Moderator> Hi, We are facing the performance issue which is impacting peoplesoft ...
Focus response time (Method R - see http://www.oreilly.com/catalog/optoraclep/chapter/ch01.pdf). Work out what is taking the time, and hence what you should do...
Hi I use the below SQL to fetch the currently running sql statement of a session. sql>select s.username, s.sid, t.sql_text "Last SQL" from v$session s, v$sql t...
What are the installation requirements for COBOL in 8.47? I know I need NetExpress v4.0 but do I install the compiler on all app and process servers like the...
I think you have your answer.... :-p peace, clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for...
Good morning all. I have changed the sysadm password using peoplesoft prefer method as below as log into data mover in bootstrap mode. CHANGE_ACCESS_PASSWORD...