1.定时任务的创建

declare

  x varchar2(20);

BEGIN

  DBMS_JOB.SUBMIT(

      JOB => x,  /*自动生成JOB_ID*/

      WHAT => 'DECLARE VAR_APPCODE VARCHAR2(200); VAR_ERRORMSG VARCHAR2(200);

                        BEGIN

                          PKG_DATASYNC.PRC_DATASYNC_CONTROL(VAR_APPCODE,VAR_ERRORMSG);

                            END;',  /*需要执行的存储过程名称或SQL语句*/

      NEXT_DATE => sysdate,  /*初次执行时间-立即执行*/

      INTERVAL => 'TRUNC(sysdate+ 1)+15/(48)' /*每隔1分钟执行一次*/

  );

  commit;

end;

备注：当INTERVAL 参数传入空值时，默认执行一次就完了。

2.终止正在运行的定时任务

begin

  dbms_job.broken(79,true);

  commit;

end;

3.删除掉定时任务

begin

  dbms_job.remove(79); commit;

end;

4.修改定时任务的下次执行时间

begin

  dbms_job.next_date(87,to_date('2021-08-30 03:00:02','yyyy-mm-dd hh24:mi:ss'));

  commit;

end;

5.查询和删除会话

select USERNAME, SID, SERIAL#, STATUS, osuser,MACHINE,PROGRAM,MODULE,ACTION,LOGON_TIME,SADDR,AUDSID,PADDR,USER#,COMMAND,OWNERID

from v$session

where username is not null

  and status = 'ACTIVE' and username='xxxxxxxx'

order by logon_time, sid;

alter system kill session '2720,15803' immediate;

6.sysdba用户授权创建DBLINK

grant create DATABASE LINK to sc_510100;

7.创建DBLINK

create database dblinkNAME

connect to username  identified by password

using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 172.18.132.136)(PORT = 9000)))(CONNECT_DATA =(SERVICE_NAME = HMHN)))';

8.删除dblink

drop database link dblinkname ;

9.查看DBlink

select * from dba_db_links;