How to find which tempory table instance is allocated to a process ?How to find which tempory table instance is Used/Allocated to a process Instance in peoplesoft ?

It is very useful if we can view the data in the temp table once process ran to Error/No Success / Success.

Usually Peoplesoft starts allocating the temp table instance from 4 (Where Online temp table instance count in the psoptions table is 3) and allocate in order for execution of AE in Parallel.If the same record is used in the other applicaiton engine programs as well it will be difficult to predict which temp table will be allocated to an Process execution (Process Instance).

Following are ways to find the temp table instance used by a process instance.

1) When process is running - In Process monitor Process Instance - Details > View locks. we can view the locks on the table. It will contain allocated temp table instance.

2) When Process ran to No Success Or Error Or Cancelled the temp table instance allocated to that Process instance will not released so that it can be by other process we can release temp table in the following component.PeopleTools > Applicaiton Engine > Manage Abends

3) When process has ran to Success and if you need to find the temp table instance used by that process instance you can query record PS_AETEMPTBLMGRIt will give you the Process instance , RECNAME , Temp table instance allocated to that process.

Facing the following error ?Temporary Table processing failure during allocation phase.Description: The Application abended due to a problem encountered during the internal housekeeping of Temporary Tables.The possible failure points are as follows:C++ memory allocation for adding new temp tables to the existing internal array.

The reason for this error will be mainly due to temp tables which are not built. The no.of instances mentioned in the AE Program properties is more than the actual Physical number of the temp tables in present in the database. During the allocation phase it allocates the next temp table which not existed physically in the data base and will cause the above all problem.

To find the no.of the temp table instances that will be built query this following recordpstemptblcntvw. This will include the table no.of instance count across all the application engine and online temp table instance.

The problem was with Process definition for one AE program that had been modified to include the trace info. When this was done, the user by mistake selected override from the parameter list drop down instead of append. The result was that the whole parameter list line was replaced with only the trace info, so the program could not run & the program was in the initiated state, this invalid parameter list was causing the above issue.

Once this process was identified & canceled the PSAESRV services was running without any issue.

The advantage of DBMS_STAT is- easier to automate- can analyze external tables.- can gather system statistics ( 9i onwards )- DBMS_STATS gathers statistics only for cost-based optimization; it doesnotgather other statistics. For example, the table statistics gathered byDBMS_STATS include the number of rows, number of blocks currently containingdata, and average row length but not the number of chained rows, averagefree space, or number of unused data blocks.

ANALYZE calculates global statistics for partitioned tables and indexesinsteadof gathering them directly. This can lead to inaccuracies for somestatistics,such as the number of distinct values. DBMS_Stats won't do that.

People code has a meta tag that can be used to update the stats on the record which will improve the performance of the record.

For Oracle Database.

%UpdateStats - It will expand to DBMS_STATS.GATHER_STATS. This can be used in the Application Engine and COBAL

The PeopleSoft Ping feature collects timestamps by sending a specific page to different tiers of the PeopleSoft system, starting at the browser, then going to the web server, the application server, the database and back. The timestamps that are collected are total time elapsed for the round trip, and arrival and departure time at each of the tiers.