2 Replies Latest reply: Jul 10, 2013 2:05 AM by user10274093 RSS

    PeopleSoft_Enterprise_Performance_on_Oracle_11g

    user10274093

      Hi  all,

       

      on FSCM 9.1, Tools 52.1, 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:

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


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

       

      from psrecdefn a, dba_tables b


      where a.rectype=7 and b.owner = ‘PSOFT’ and b.table_name like 'PS_'||recname||'%';


      5. Run the script created in step 4 through sqlplus.

      =====end of document=========================

      We didstep 3. But in step 4 the last query brings no row.

      Do you have any idea ?

       

      Thanks