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...
James, I don't have an available test environment at the moment so I can't check this out myself. I looked at the BEA docs and have a couple of questions....
Thanks all, I don't have an test environment either to test that out. But I am curious to know how to make it automated and not manually run each time in the...
Hi, We had another problem regarding nvision, this is 8.4.12 pstools/FM. On the new server, the sqr run successfully. However, nvision just sit there with...
Hi all, I am new to this group and to Installation of Peoplesoft. I installed Peopletools version 8.12 . But I couldn't open any of the existing peopletools...
shan_mu2k
shan_mu2k@...
Mar 18, 2004 8:06 am
524
Oh boy. We've found that nVision can be quite flakey. Here are some initial things to check... First kick off an nVision process so that it becomes 'hung'......
Well, if you wanted the Distribution Agent to be unavailable during a regular time period, you could just write the appropriate commands into a pair of shell...
Hi Henry... ... Well, new content is definitely not posted while the Distribution Agent's queue is suspended. It might be a little more difficult to see what...
I had a go at testing this on PT8.44. It seems that the distribution agent now responds to the PostReport service issued by the process scheduler. This has to...
David Kurtz
david.kurtz@...
Mar 23, 2004 12:37 pm
529
Has anyone noticed huge gains by enabling Query Access List Cache? From GSC... Here is how you can tell if the cache is working: 1) clear the access list cache...
Hi All, We have attended regional user group recently and understood rom PeopleSoft support VP that the Change assistant will be available to customers from...
Hello, Can someone tell me if trace files do get rotated when tracing an application server domain with the additional option to the command line: CLOPT ="-r...
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.
