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...
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
3838
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...
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...
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
3841
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...
There is a red paper on PeopleSoft site which talks "PeopleSoft Enterprise Performance on Oracle 10g Database" please read it ....  BTW per this paper ...
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
3844
Can anyone give me a way to check (or tell me if you know) the memory footprint of a process server in PeopleSoft. I have a script which purports to give the...
Hello *, Is there a way to check in a PPLsoft DB if all the foreign keys are indexed? Regards, Willem ... ATTENTION: The information in this electronic mail...
Willem.Leenen@...
Jul 21, 2009 12:46 pm
3847
There are no foreign keys defined in the database by PeopleSoft. regards _________________________ David Kurtz Go-Faster Consultancy Ltd. tel: +44 (0)7771...
If you mean that the referential integrity isn't defined in the database, I agree. It's one of those applications where the referential integrity is managed in...
Willem.Leenen@...
Jul 21, 2009 1:43 pm
3849
Hi Everybody, I am working on a development environment which has Oracle 9.2.0.6 database and People Tools release 8.42. We are receiving SQR 6806 error while...
Does anyone know what PeopleSoft tables are queried to get the information that is used for the compare reports? Specifically, I have some changes identified...
Back in the 2000 US presidential election... OK, just kidding.. Whenever a query is cancelled or times out in PeopleSoft, the underlying query in the database...
Clark, The flags that are set in the compare reports that are set can be found in the table PSPROJECTITEM. If you wish to find out who has changed a particular...
One of our Application engine service PSAESRV restarted suddenly in Production . Below is the tuxedo log generated.We came to know about this after one of the...
It depends why the PSAESRV process has died. LIBTUX_CAT:541 just means that the process has terminated. That message is generated by the BBL process which...
Hi Dear All, I have production database with with 24x7. 6 redo log groups with 1 member in each. databse size is 75GB. but frequent massage is comming in alert...
what flavor of database? Access? peace, clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40...
How big are the redo log files? How often are they switching? regards _________________________ David Kurtz Go-Faster Consultancy Ltd. tel: +44 (0)7771 760660...
Hi Dear All, I have Oracle 10gR2 production database with with 24x7. 6 redo log groups with 1 member each of 50MB size. Total databse size is 75GB. but...
You probably need larger log files (rather than more log files). Depending upon the size of the system, I have seen redo logs of up to 2Gb used. As a very...
Dear All DBA's Any one knows. In my database total size of table is 25GB. I have deleted 50% rows of the table. but it doesn't show the free space of removed...
That is how Oracle works. If you have DELETEd rows, space allocated to the segment (table and any indexes) is not relinquished. To relinquish space back to...
Hello Everyone, Can you please let me know the answers for these two questions. 1) Does peoplesoft application server uses jdbc, if so which version...
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.
