Has confirmed that the job is in the execution, but can't see the session in the session, also can't see the corresponding record in the dba_job_running, sometimes it may happen, sometimes normal
What a great god? To know is where is there a problem? How to solve,

CodePudding user response:

May perform in for some reason will be in a state of "INACTIVE"?

CodePudding user response:

To view ALL SESSION, also didn't see the corresponding SESSION, and confirmed that the job is in the execution, parallel query SQL execution in the job, and can see the parallel SESSION, but is can't see the corresponding job SESSION,

CodePudding user response:

refer to the second floor xc1342211973 response:

view ALL SESSION, also didn't see the corresponding SESSION, and confirmed that the job is in the execution, parallel query SQL execution in the job, and can see the parallel SESSION, but is can't see the corresponding job SESSION,

PLSQL dev? Background process even to filter out?

CodePudding user response:

Database is a standalone or RAC?

CodePudding user response:

reference 4 floor select_update_insert response:

database is a standalone or RAC?

The virtual machine and blade are the same

CodePudding user response:

Check your pl/SQL statements written whether there is a problem, tracking,

CodePudding user response:

1. Stop the job
The exec DBMS_JOB. BROKEN (124, SYS. DIUTIL. INT_TO_BOOL (1));
2. The query is executing the job
Select * from dba_jobs_running;
3. Check the job session information
Select * from v $session t where t.S ID='403'.
4. Kill off the session
The ALTER system KILL session '403861'.
Must stop the job first, then kill the process, otherwise after killing process, oracle will continue to perform the job, until after the specified number of times, stop,