Does anyone here know how peoplesoft launches the jvm for its peoplecode sessions? I want to start the peoplecode java session inside my own container, so i...
Is anyone using Peoplesoft Financials 8.8 with Peopletools 8.44 yet? I'm particularly interested in hearing from 7.5 upgraders. Regards Shirley "The...
Hi, I am looking for a user friendly documentation of settingup of Reverse Proxy Server with simple steps. I would be thankful if someone can provide this...
I am looking for a script which can monitor to check whether the Peoplesoft Weblogic domain is up and running or not. We have multiple domains in our...
Hello, we are on production for 2 months with global payroll and time and labour, and as expected, the payroll tables are growing very fast, in particular the...
Benoît If you are using streaming in payroll you should range partition all the tables that are updated by the payroll to match the streams. Streaming is ...
David Kurtz
david.kurtz@...
Feb 16, 2004 9:46 pm
497
I need to reopen an old SA760 DMO/SYS database. Is there any other table then PSRELEASE or PSLOCK where I can find the real Tools version in which the...
Hello I hadn't thought of looking on PSRELEASE. It's a good idea and probably the best indication that you will get. On PeopleTools 7.5 only the major release...
Thanks for the two-tiers remark Yoiu wrote: "I would suggest using the latest version of PeopleTools that you have and if necessary go through the PT upgrade...
Hello, Don't know whether this table also existed in the PT 7.5 release but in 8.1x and further you also have the PS_MAINTENANCE_LOG table. When installing...
Jorg Sander
ozzkaar@...
Feb 18, 2004 7:38 pm
501
Hi All, Our client is planning to implement the row-level security in PS-Financials 8.4 at the DEPT level, Hence need some suggestions if anybody has done it...
Dear Fans, I installed App server and apache server suceefully.While Booting app server also no problem.When I tried to connect to web browser the problem I am...
venkattr
venkattr@...
Mar 1, 2004 7:38 pm
503
Hello, We have a requirement to find out query usage on our system. Basically what we are looking for is a list of queries and the number of times they have...
Lrajapakse@...
Mar 1, 2004 7:38 pm
504
Tools 8.19 Oracle 8.1.74 When users kill their sessions on the client .The process is not killed in Oracle .Is there any recommended way to handle this ? I...
michael.ngong@...
Mar 1, 2004 7:50 pm
505
This should list all sql with the same first 100 letters that has occurred at least 89 X select substr(sql_text ,1,100) sameSQL,count(*) from v$sql group by...
michael.ngong@...
Mar 7, 2004 7:56 am
506
Is it a good practise to use Materialized view over view in Oracle. We have build lot of customized view and would like to create materialized to improve...
Tripathi, Tushar Mani
tushar.mani.tripathi@...
Mar 7, 2004 7:56 am
507
Are you sure that PeopleSoft supports Apache? In the installation documention, I have only seen sections for IBM Web Sphere and BEA Web Logic. Stephen J. IQCS...
How are your users killing their sessions? Aren't they signing off in the application? Anyways, have you checked the status of the sessions in v$session?...
What database are you using for your backend? If it is Oracle, you can then query v$sql, v$sqltext, v%sql_cursor to get some of this information. Stephen J. ...
Hi, Is there somebody that has used Windows Load Balancing Service in combination with PeopleTools 8.1x using WebLogic 5.1 as webserver? And if so are there...
Jorg Sander
ozzkaar@...
Mar 7, 2004 7:57 am
511
Hello I'm trying to ascertain how many concurrent runtime licenses we would need to purchase for HR/Payroll. Do the self service functions require cobol...
What OS is the database on? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA ... From: joness59 [mailto:joness59@...] Sent: Tuesday, March 02, 2004...
Goulet, Dick
dgoulet@...
Mar 7, 2004 6:02 pm
513
Materialized view is the OLD name for a snapshot. Replacing your views with MV's would improve performance, but changes to the underlying tables of the...
Goulet, Dick
dgoulet@...
Mar 7, 2004 6:02 pm
514
Assuming they have not been flushed from the shared pool. Quering the V$ table fro them type of stuff is problematic since what your interested in doesn't...
Goulet, Dick
dgoulet@...
Mar 7, 2004 6:02 pm
515
Materialized Views are the NEW names for snapshots. The optimizer will use an MV if it determines that it is cheaper than using the underlying tables. Also...
David Kurtz
david.kurtz@...
Mar 8, 2004 7:29 am
516
Hi, I came up a question, is there anyway to hold the distribution node agent for one hour or so to deleted the output report from the log directory and then...
What tools release are you on? In 8.4, there is a page/panel that allows you to define operation times for each Process Scheduler, but I believe it applies to...
You can unadvertise a tuxedo service in tmadmin. However, if the service is not available anywhere it doesn't queue up, you get an error message. I don't...
David Kurtz
david.kurtz@...
Mar 12, 2004 9:41 am
519
I was thinking about the suspend/resume commands. I tried them out in our QA environment, PT 8.42.09. Placing the DSTQ queue in Suspend status ('suspend -q...