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. ''; ;
Suscribirse a:
Enviar comentarios (Atom)
No hay comentarios:
Publicar un comentario