重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: 查询DBA_JOBS 发生ORA-01873 [打印本页]

作者: 刘泽宇    时间: 2025-12-21 11:12
标题: 查询DBA_JOBS 发生ORA-01873
概要
查询DBA_JOBS 发生ORA-01873

ORA-01873: the leading precision of the interval is too small

解决方案
查询 DBA_JOBS 时不要选择列 TOTAL_TIME,选择其他的列来获取信息。

或者

查询 DBA_SCHEDULER_JOBS,可以查到所有的Job,包括通过DBMS_JOB 创建的Job。
select * from dba_scheduler_jobs;


原因
请注意,Scheduler 将不会跟踪Job 的TOTAL_TIME。

Database Preupgrade tool check list. (Doc ID 2380601.1)
Starting with Oracle Database 19c, jobs created and managed through DBMS_JOB package in previous database versions
will be re-created using Oracle Scheduler architecture. Jobs not successfully re-created may not function properly after upgrade.






欢迎光临 重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2