Tenha certeza que o portal esta coletando as estatisticas.<\/p>\n
Fa\u00e7a o login como PORTAL e execute: <\/p>\n
SQL> exec dbms_stats.delete_schema_stats (ownname=>’PORTAL’); — analyzing PORTAL schema statistics is *NOT* supported
SQL> exec wwsbr_stats.delete_stats; — delete Portal statistics
SQL> exec wwsbr_stats.gather_stats; — create Portal statistics
SQL> exec wwsbr_stats.enable_monitoring; — Habilitar o DML sobre as tabelas se for necess\u00e1rio
SQL> exec wwsbr_stats.gather_stale;
SQL> commit;<\/p>\n
Nota:
+ Para desabilitar Portal DML monitoring : exec wwsbr_stats.disable_monitoring
+ Para configurar o JOB: $ORACLE_HOME\/portal\/admin\/plsql\/wws\/statsjsub.sql ‘START’ ‘NOW’ ’24’ => a cada 24 horas.<\/p>\n","protected":false},"excerpt":{"rendered":"
Tenha certeza que o portal esta coletando as estatisticas. Fa\u00e7a o login como PORTAL e execute: SQL> exec dbms_stats.delete_schema_stats (ownname=>’PORTAL’); — analyzing PORTAL schema statistics is *NOT* supportedSQL> exec wwsbr_stats.delete_stats; — delete Portal statisticsSQL> exec wwsbr_stats.gather_stats; — create Portal statisticsSQL> … Continue lendo