Esto nos permite un mejor acceso a los datos y un performance ingon:
Movemos las tablas e indices a un tablespace con extents uniformes:
alter table SYSADM.PS_BR_DAD_TBL MOVE tablespace GAPPC;
alter index SYSADM.PS_BR_DAD_TBL REBUILD tablespace PSINDEXC;
alter table SYSADM.PS_GP_PI_MNL_DATA MOVE tablespace GAPPC;
alter index SYSADM.PS_GP_PI_MNL_DATA REBUILD tablespace PSINDEXC;
alter table SYSADM.PS_GPMX_SDIVAR_WA MOVE tablespace GAPPC;
alter index SYSADM.PS_GPMX_SDIVAR_WA REBUILD tablespace PSINDEXC;
Y se ejecutan las estadisticas
execute dbms_stats.gather_table_stats(ownname=> 'SYSADM', tabname=> 'PS_BR_DAD_TBL',estimate_percent=> 100 cascade=> TRUE);
execute dbms_stats.gather_table_stats(ownname=> 'SYSADM', tabname=> 'PS_GP_PI_MNL_DATA',estimate_percent=> 100 cascade=> TRUE);
execute dbms_stats.gather_table_stats(ownname=> 'SYSADM', tabname=> 'PS_GPMX_SDIVAR_WA',estimate_percent=> 100 cascade=> TRUE);
