Check the actual operating scheme of the failed Oracle JOB

Do you have a headache in checking the actual operations of expired Oracle jobs? If this is the case, the following articles will give you corresponding solutions. The following articles mainly introduce solutions for checking invalid Oracle jobs. The following describes the specific content.

 
 

  
  
SELECT * FROM dba_jobs WHERE broken=
'Y' OR failures>0 OR next_date < trunc(SYSDATE); 
 
 

Check failed mview refresh

 
 

  
  
SELECT * FROM dba_mviews WHERE compile_state!=
'VALID' ORDER BY last_refresh_date; 
 
 

View the system resources that the session is waiting for. SQL

 
 

  
  
SELECT gv$session.inst_id,gv$session.sid,gv$session.serial#,  
  
  
gv$session.username,gv$session.machine,gv$session.program,  
  
  
gv$session_wait.event,gv$session_wait.p1text,gv$session_wait.p1,  
  
  
gv$session_wait.p2text,gv$session_wait.p2,  
  
  
gv$session_wait.p3text,gv$session_wait.p3,  
  
  
gv$session_wait.seconds_in_wait,gv$session_wait.state  
  
  
FROM gv$session,gv$session_wait  
  
  
WHERE gv$session.inst_id = gv$session_wait.inst_id AND  
  
  
gv$session.sid = gv$session.sid;  
 
 

Query the waiting object according to the waiting event. SQL

 
 

  
  
select owner,segment_name,segment_type,tablespace_name  
  
  
from dba_extents where file_id=152 
  
  
and 239210 between block_id and block_id + blocks -1;  
 
 

The above content describes the actual code of the Oracle JOB that fails to be checked. We hope it will help you in this regard.