11 2019 档案
摘要:1.查看所有的 jobs select t.* from user_jobs t 2.创建 jobs declare job_id pls_integer; begin sys.dbms_job.submit(job => job_id, what => 'proc_balance_fix_mon;
阅读全文
摘要:1.查询锁表的信息 select sess.sid,sess.serial#, lo.oracle_username,lo.os_user_name, ao.object_name,lo.locked_mode from v$locked_object lo,dba_objects ao,v$ses
阅读全文