... security ... appears ... Yeah, that is what I see in v$sqlarea. Not very good for parsing overhead...! ... OK, so you can influence the binding to a...
I know of no way to control the management of cursors in PeopleCode. I suppose you could always put PL/SQL in AE, but that is how to make life difficult for...
699
mattmcclernon
mattmcclernon@...
Sep 13, 2004 11:11 am
... set ... Dave, Thanks for the feedback.. The hard parsing issue is not a problem in this case because bind variables are being used. It is the soft parse...
698
David Kurtz
david.kurtz@...
Sep 9, 2004 5:45 pm
Hello All I appreciate that the DBA forum has a global reach, but for those of you in Europe, you might be interested in the following: regards ...
Unfortunately, nothing is as well thought out as that. The RAC system will be at the site I am currently at (but about to leave). It's going RAC because it's...
OK. So why is you friend doing this? what is the rationale? what do you hope to achieve? How are you planning to structure the PeopleSoft infrastructure? Are...
We are running RAC and Dataguard on HRMS 8.1 Tools 818 and have been doing so for a year or so. Let me know if I can help with anything Steve Montgomerie ...
Hello All, PT 8.41.20 - Oracle 8.1.7.2 - Sun Solaris 8 My audit department want me to look into providing a mechanism for stopping users from manually posting...
If you want to tackle hard parsing in SQL from Applicaiton Engine steps with litterals you can set the ReuseStatement attribute is set to `yes' on the AE step,...
692
mattmcclernon
mattmcclernon@...
Sep 8, 2004 1:42 pm
Does anyone know of a way of reducing the parse overhead of Application Engine processes which run the same SQL statements repeatedly. The App Engine program...
691
mattmcclernon
mattmcclernon@...
Sep 8, 2004 1:41 pm
... No, but I am seriously considering it for next year... Do you have any specific questions. Matt...
At the time we did this, 8.45 was available as a new install only, not as part of an upgrade path. So we upgraded to 8.44 instead of waiting for 8.45, since...
I appologize that this is not related to the original post, as I don't know enough about WL 8.1 at this point to comment... Are/were you installing a patch to...
Hello Is anyone out there using any version of PeopleSoft on an Oracle RAC cluster? regards _________________________ David Kurtz Go-Faster Consultancy Ltd. ...
PeopleSoft Ping is not a good test of database performance, because the same rows are repeatedly read by successive pings and so they are likely to be cached...
684
kclew@...
Sep 6, 2004 6:03 pm
Hi All, I've tested between Oracle 9i and Informix 11 (not exactly sure which version) for the PeopleSoft ping function, running in the same box on exactly...
Yep :-) of :-( Andy ... From: BL Barske [mailto:BL.Barske@...] Sent: maandag 6 september 2004 8:52 To: abaird@...;...
682
Jörg Sander
jorg_sander@...
Sep 6, 2004 6:02 pm
Hi, Is there anybody who already implemented eRecruitement and connected PSFT to the Internet? We would like to have some information about the infrastructural...
Bert <MODERATOR>I know Andrew will fully understand this, but the rest of us are struggling!</MODERATOR> I think it is also appropriate to point out that the...
Hi, een hele stap. Zeker een management beslissing :>) Ik heb geen directe ervaring met de overstap (ook niet met PS 8). Wij gebruiken nog de 7 serie voor HR,...
Hi all, Thanks for the information. If there is amything else please let me know. Cheers Andy ... From: Goulet, Dick [mailto:dgoulet@...] Sent: vrijdag 3...
... I should add that both our Sybase and Oracle were running on Solaris UNIX. Regarding performance, We went from an old 'slow' 8 processor server to a new...
677
Goulet, Dick
dgoulet@...
Sep 3, 2004 1:56 pm
Ditto on the locking models working differently. We've an equipment maintenance application using SQL*Server. If two line techs are working on two relatively...
676
Carol Dacko
cdacko@...
Sep 3, 2004 1:34 pm
Andy, There are distinct differences in running the two RDBMS. The consistency model is very different is SQLServer than Oracle. The locking models are ...
... We changed from Sybase to Oracle during our upgrade from 7.5 to 8.4. Sybase is closely related to SQL Server. Most of the problems we encountered were in...
Hi All, there is a though here to start using SQlServer instead of Oracle as the main choice of Database. Does anybody out there have experience with...
Are there users deployed on Peoplesoft 7.53/PeopleTools 7.63/Oracle 9.2.0.5 ? Are there any special issues encountered with this configuration, related to the...
