参考(17条消息) Oracle 11g自带的系统Job介绍_oracle11gjob_shayuwei的博客-CSDN博客
SQL> select job_name from dba_scheduler_jobs;
SQL> set lin 160 SQL> col owner for a10 SQL> col DIRECTORY_NAME for a25 SQL> col DIRECTORY_PATH for a50 SQL> select * from dba_directories where DIRECTORY_NAME like '%OCM_CONFIG%';
set lin 160 col owner for a10 col DIRECTORY_NAME for a25 col DIRECTORY_PATH for a50 SQL> SQL> SQL> SQL> select * from dba_directories where DIRECTORY_NAME like '%OCM_CONFIG%'; OWNER DIRECTORY_NAME DIRECTORY_PATH ORIGIN_CON_ID ---------- ------------------------- -------------------------------------------------- ------------- SYS ORACLE_OCM_CONFIG_DIR2 /home/db/oracle/product/19.3.0/ccr/state 1 SYS ORACLE_OCM_CONFIG_DIR /home/db/oracle/product/19.3.0/ccr/state 1
Oracle 11g的自带的Job，使用select * from Dba_Scheduler_Jobs;可查询到。介绍如下：
标签：OCM,NAME,禁用,DIRECTORY,job,SQL,oracle,col,select From： https://www.cnblogs.com/dbahrz/p/17276476.html