Oracle recommendation for PeopleSoft

Hi all,

on DB Oracle 11g, on Win 2008

in RED_PAPER_-_PeopleSoft_Enterprise_Performance_on_Oracle_11g_Database.pdf

it is said :

2. Build a SQL script to delete statistics of temporary tables that have stats of 0 rows using this SQL

command:

select 'exec DBMS_STATS.DELETE_TABLE_STATS ('|| 'ownname =>' || ''''|| b.owner || '''' || ','

|| ' tabname =>' || '''' || b.table_name || ''');'

from psrecdefn a, dba_tables b

where a.rectype=7 and b.num_rows=0 and b.table_name like 'PS_'||recname||'%';

3-Run the script created in step 2 through sqlplus.

4. Build a SQL script to lock statistics of all temporary tables using this SQL command: