Hello All, I have installed one peoplesoft server with HRMS application and installed multiple language patch with every language selected. During databse...
you have to use DMS and load the db scripts for the languages you want to add. peace, clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary,...
Hi, thanks for your reply. Can you explain me in details.It will help me a lot. Waiting for your reply. Thanks Shailesh ... want to add. ... renting your...
Hello All, Has anyone experienced this scenario before? PSQuery/Query Manager running very slow: a. Running a search in PSQuery is very slow b. Running query...
The query tool, by nature, is very slow, especially if you use row level security. I don't know what causes this, other than the fact that it goes through PS...
Have you set the initialisation parameters recommend by the platform advisory (linked from the certification report) on customer connection? Have you got a...
Can anyone give me details on SAMPLE_SIZE column (in ALL_TABLES)? I need detailed information on this column. Few PS Queries, which is using JOB record is...
My friend finished his installation successfully today. Thanks for all the responses, really helped! Max Max Wang <jz_nj2006@...> wrote: My friend who is...
Can you please post the explain plan of the sql query. ________________________________ From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com] On...
When you gather statistcs with estimation instead of calculation. Estimation takes a percentage of blocks (sample size) in order to estimate rows for table It...
Hi, SAMPLE_SIZE is the % used for statisics collection. Are you able find any SQL from v$session_long_ops. Either a trace or Explain plan for the offending...
Bobby, 1) Does psadmin or tmadmin's qstatus showing queuing? If so how much? 2) Could these sporacdic events be caused by large messages overflowing queue and...
I preparation for testing the pre-loading cache functionality in a ptools 8.48 instance, I checked Performance Monitors Component Cache Misses on a test system...
Here is the explain plan from DEV. Paste it in Notepad... With Font: Lucida Console (Regular,10). It will be visible in formatted way.... ... I tried to...
For a start, it looks like you're missing maybe all index(es) on sjt_person and certainly an index on whatever columns join to job_jr. Robert Ellis PSE Data...
Not necessarily. Oracle has chosen to start with the security table, and so it doesn't have any selective criteria, so it enevitably does a fully table scan. ...
Hello, When you mentioned the "sample_size" column of all_tables having a smaller value in production than you have in your development environment it reminded...
Hi all, Does any one know how to resolve the following error in datamover? Started: xxx Data Mover Release: 8.46.17 Database: xxx SQL Successful - DELETE...
Open a case with PS GSC... Just off the top of my head, it looks like your tools level might be off. peace, clark 'the dragon' willis PSA: Salary <> Slavery....
Does the table SET_CNTRL_REC show up in your dddaudit report? It might have to do with the structure of the table defined in App Designer. - Stanly ... Does...
We were able to correlate the time the statistics were incorrectly gathered with the execution of the PO_PORECON application process associated with the Manage...
Hi All, I am having HRMS8.9 with PT 8.47 and DBMS oracle 9i. My problem is 1. There are two occurance/rows of sqr report in the Process Scheduler Request page...
I might be stbo here but two rows in psprcsrqst almost always means that the process has been scheduled twice. In this case this looks to be the fact as there...
Or do you mean that there are mutliple entries for the same report in page where you choose which process to run? Which could be because the process is...
Hi David, Yes what you understand from my mail is correct that there are mutliple(two) entries for the same report(particularly for sqr report only) in Process...
The list of things that you can run is built by a query, with a DISTINCT to remove duplicates. The same thing is described differently in different places -...
I manage an instance of PeopleTools 8.43.16 running on Oracle 9.2.0.8. Users are having significant problems with randomly being redirected to the login page....
ummm, how about looking on the webserver for the problems?PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a...
