set time ON
set timi ON
set echo ON

spool /NFS/BBDD/oracle/dmiranda/migrispac/16_estadisticas.log

EXEC DBMS_STATS.gather_schema_stats(ownname=>'AAGUILAR',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'AAMOJ',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'ACASTANGI',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'ACC_ADMIN',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'ADMINISTRADOR',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'AJRUIZR',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'ALCABELLO',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'ALOPEZDIAZ',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'AOLMEDOL',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'ASAENZ',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'ASANCLEMENTE',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'BDMSAINF_OWN',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'BDMSAINF_USR',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'BLERIN',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'CRICO',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'CRUBIO',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'DBAOPER',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'DBENEDET',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'DGARCIABA',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'DGONZALEZ',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'DMARTINEZG',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'DMIRANDA',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'DNARANJO',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'DPEREZDELPALOMAR',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'DSAENZM',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'EFORNIES',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'EGARRIGA',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'FJMARTON',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'FLOPEZ',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'GCAYETANO',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'HFRANCIA',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'INDASIST',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'INDRASALUD_RIS',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'INDRASALUD_RIS_PRE',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'INDRASALUD_RIS_300',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'JALVAREZPE',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'JDEALFONSO',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'JFICHEUX',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'JMAESTRO',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'JPMOYA',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'JVBELSUE',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'JVITALLER',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'LCUESTA',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'MBORJA',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'MIRTH_PPAC_OWN',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'MMURLA',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'MONITOR_READ',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'MPALOMINO',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'MVIEWADMIN',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'MVSITE',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'NGRAU',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'NPSMIRTH',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'NPSMIRTH_PRE',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'NPSMIRTH2',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'OCALVOG',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'OPERDP',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'PABASCAL',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'PRUEBAS_EXT_OWN',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'PRUEBAS_EXT_USR',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'RAIMCACHE',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'RAIMSERVER',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
--EXEC DBMS_STATS.gather_schema_stats(ownname=>'RAIMSERVER_PRE',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'RAIMWEBDESK',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'RCIPRES',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'RJCABRERA',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'RJIMENEZ',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'SCEBRIANL',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'SCOBOS',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'SOPORTE',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'SPMAGIC',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'STORRES',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'VMENDEZ',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);
EXEC DBMS_STATS.gather_schema_stats(ownname=>'YCAMBRA',estimate_percent=>80,block_sample=>true,method_opt=>'for all indexed columns size auto',degree=>1,granularity=>'ALL',cascade=> true,force=>true);

spool off;

