Hi SP, Thank you for the hints. I am surprised to hear that the optimizer_dynamic_sampling should be set to zero for the PPLsoft database. I am on Oracle 9,...
Willem.Leenen@...
Jul 9, 2009 10:10 am
3842
There is a red paper on PeopleSoft site which talks "PeopleSoft Enterprise Performance on Oracle 10g Database" please read it ....  BTW per this paper ...
Willem, I was not trying to contradict your statement. As you clarified, exceptions needs to be handled in both cases. The choice to analyze full or at a...
Shaji, I don't see any difference in our opinions. If your posting was meant to counter mine, then one of us wasn't clear. The only exception is in the last...
Willem.Leenen@...
Jul 7, 2009 3:06 pm
3839
I think you can usually take default sample size by using DBMS_STATS.AUTO_SAMPLE_SIZE. There might be a few tables where you need to collect statistics at a...
Willem, Decision to collect complete statistics can be made only based on the size of the db and how long it takes to capture the stats on a daily basis. I...
Hi Brian, Your question cannot be answered with the information provided. Calculation of statistics is an optimalisation game, where the time to gather...
Willem.Leenen@...
Jul 7, 2009 10:46 am
3836
Hello Everyone,
We have upgraded from Oracle 9i to 10g (10.2.0.4).
We are trying to understand the behaviour of DBMS_STATS in our new
environment.
In...
lol. The only suggestion I have is get them the hell off db2 and onto Oracle. When will companies learn? peace, clark 'the dragon' willis PSA: Salary <>...
Hi, Â Application: HCM 9 PT 8.49 Â Has any body here used DB2 UDB for Z/OS with Peoplesoft. What is your experience in setting up and maintaining the DB ? Do...
That's certainly not the way we did it.... and I can not imagine any reason to do so - is that what the installation guide suggests? peace, clark 'the dragon'...
Hi, We plan to install peoplebooks in our unix box. But recently I just came to see a document that we need to install the peoplebook first in windows machine,...
Does anyone has a step by step guide to install peoplebooks PT8.49.21 and Fin SCM 9.0? I have followed the installation guide as follows: Create weblogic...
We are installing Crystal 9 SP7 as required by PeopleSoft. Their directions say to run the install and copy certain .dll files from C:\Program Files\Common...
Hi all, Â When I run the PSQuery through 2-tier or ron to Excel or Run to HTL, it runs fine, but when I schedule the query, the process just go to success...
Hi DBA's, Any of you has some prior experience of implementing Cyber Source credit card integration with FMS 9 on 8.49 Regards, Prasad Hi DBA's, Any of you...
You can get pretty good but not perfect data models via your account manager. After that, it's all SQL. Of course, no good looking at the database schema for...
I hope some one may have encountered this issue before, I have a multi box dev system two app/web servers on a dns round robin, windows 2000 pt8.21.07, Tuxedoe...
Colleagues! I have to find or devise methodologies and mechanisms for a fairly comprehensive operation that will check the data integrity (orphans, foreign...
Hello I setup peoplebooks help but when i hit F1button from my computer peoplebooks help is not opening. Some one help me on this please. even put the...
To make it very simple,  my take would be (assumption no tools upgrade is involved here)  for Oracle upgrade you do not need to change any thing on...
Hi David,
I hoped it might be something like that.
So, if I have understood this correctly, it seems to me that setting
DbFlags=8 will be ok for us,...
I have just realised that I was slightly misleading in my previous post. These are the bits defined in the app server config file. They can be set indepently. ...
Hi David,
Thanks very much for that clarification.
As you know we don't have a large numbers of users on our PeopleSoft
system
so it would seem likely...
dbflags=8 diables the secondary session in App server. This second database session is used for sequence number generation. Conceptually, It is similar to...
Hello everyone,
We are upgrading our Oracle database from version 9.2.0.8 to 10.2.0.4.
Our Tools version is 8.49.13
One of the changes that PeopleSoft...
<Moderator>Since this is a production problem you should of course log a P1 service request with Oracle support. The forum is not a substitute for Oracle...
Well, in sql server we don't have concept of tnsfiles. It's more powerful. You can just simply enter the sqlserver name or machine ip address in the ODBC...
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.
