martes, 1 de julio de 2014

LIMPIAR BASELINES

 select * from DBSNMP.BSLN_BASELINES;
      DBID INSTANCE_NAME    BASELINE_ID BSLN_GUID TI A STATUS       LAST_COMP
---------- ---------------- ----------- -------------------------------- -- - ---------------- ---------
2150325182 orcl      0 6451AA8D042DB3D952214555174DC9DA HX Y ACTIVE       02-FEB-14
2150325182 orcl      0 4C22FDB287A43E1D9BD50E06047E35F7 NX Y ACTIVE       02-FEB-14
 delete from DBSNMP.BSLN_BASELINES where INSTANCE_NAME='orcl';
1 row deleted.
> select * from DBSNMP.BSLN_BASELINES;
      DBID INSTANCE_NAME    BASELINE_ID BSLN_GUID TI A STATUS       LAST_COMP
---------- ---------------- ----------- -------------------------------- -- - ---------------- ---------
2150325182 orcl      0 6451AA8D042DB3D952214555174DC9DA HX Y ACTIVE       02-FEB-14
> commit;
Commit complete.
> exec dbms_scheduler.run_job('BSLN_MAINTAIN_STATS_JOB',false);
PL/SQL procedure successfully completed.
> select log_date,status from dba_scheduler_job_run_details where job_name='.BSLN_MAINTAIN_STATS_JOB. '';  ;