The script below will return any error in Oracle Concurrent Request for 7 days

SELECT a.request_id "Req Id"

,a.phase_code,a.status_code

, actual_start_date

, actual_completion_date

,c.concurrent_program_name || ': ' || ctl.user_concurrent_program_name "program"

FROM APPLSYS.fnd_Concurrent_requests a,APPLSYS.fnd_concurrent_processes b

,applsys.fnd_concurrent_queues q

,APPLSYS.fnd_concurrent_programs c

,APPLSYS.fnd_concurrent_programs_tl ctl

WHERE a.controlling_manager = b.concurrent_process_id

AND a.concurrent_program_id = c.concurrent_program_id

AND a.program_application_id = c.application_id

AND a.status_code = 'E'

AND a.phase_code = 'C'

AND actual_start_date > sysdate - 7

AND b.queue_application_id = q.application_id

AND b.concurrent_queue_id = q.concurrent_queue_id

AND ctl.concurrent_program_id = c.concurrent_program_id

AND ctl.LANGUAGE = 'US'

ORDER BY 5 DESC;

 

You are welcome to leave a comment....

Long Running Oracle Applications Jobs

SELECT a.request_id "Req Id"

,a.phase_code,a.status_code

, actual_start_date

, actual_completion_date

,(nvl(actual_completion_date,sysdate)-actual_start_date)*1440 mins

,(SELECT avg(nvl(a2.actual_completion_date-a2.actual_start_date,0))*1440 avg_run_time

FROM APPLSYS.fnd_Concurrent_requests a2,

APPLSYS.fnd_concurrent_programs c2

WHERE c2.concurrent_program_id = c.concurrent_program_id

AND a2.concurrent_program_id = c2.concurrent_program_id

AND a2.program_application_id = c2.application_id

AND a2.phase_code || '' = 'C') avg_mins

,c.concurrent_program_name || ': ' || ctl.user_concurrent_program_name "program"

FROM APPLSYS.fnd_Concurrent_requests a,APPLSYS.fnd_concurrent_processes b

,applsys.fnd_concurrent_queues q

,APPLSYS.fnd_concurrent_programs c

,APPLSYS.fnd_concurrent_programs_tl ctl

WHERE a.controlling_manager = b.concurrent_process_id

AND a.concurrent_program_id = c.concurrent_program_id

AND a.program_application_id = c.application_id

--and a.phase_code in ('I','P','R','T')

AND a.phase_code = 'C'

AND actual_start_date > sysdate - 20

AND b.queue_application_id = q.application_id

AND b.concurrent_queue_id = q.concurrent_queue_id

AND ctl.concurrent_program_id = c.concurrent_program_id

AND ctl.LANGUAGE = 'US'

AND (nvl(actual_completion_date,sysdate)-actual_start_date)*1440 > 10

AND (nvl(actual_completion_date,sysdate)-actual_start_date)*1440 >

( SELECT avg(nvl(a2.actual_completion_date-a2.actual_start_date,0))*1440

FROM APPLSYS.fnd_Concurrent_requests a2,

APPLSYS.fnd_concurrent_programs c2

WHERE c2.concurrent_program_id = c.concurrent_program_id

AND a2.concurrent_program_id = c2.concurrent_program_id

AND a2.program_application_id = c2.application_id

AND a2.phase_code || '' = 'C'

)

ORDER BY 5 DESC;

 

You are welcome to leave a comment....

ORACLE SERVER ARCHITECTURE

You are welcome to leave a comment....

Profile Option Values for Oracle DB User

Oracle DB User Profile Option Values
FAILED_LOGIN_ATTEMPTS	Means for how many times you can try to login.. After these many sequential unsuccessful tris to login, the user account will be locked for the days specified in PASSWORD_LOCK_TIME. (i.e. LOCKED (TIMED)).
PASSWORD_LOCK_TIME	for this much amount of time, your password wil be locked, if your account is locked because you are failed to login successfully .
PASSWORD_GRACE_TIME	the number of days, after your password expires. During that time, user can use that password, but reminded to change password.
PASSWORD_LIFE_TIME	the number of days, the password can remain in force.
All the possible values are decided by below mentioned parameters
OPEN	you can use this acccount to login.
EXPIRED	Account is expired as you have tried to unsuccessfully login for 3 times.
EXPIRED(GRACE)	Means, account is expried but grace is given to change the password.
LOCKED(TIMED)	Account is locked as you have tried to unsuccessfully login for FAILED_LOGIN_ATTEMPTS times.
EXPIRED(GRACE) & LOCKED(TIMED)
EXPIRED & LOCKED
EXPIRED(GRACE) & LOCKED

You are welcome to leave a comment....