Queries Arsenel for Oracle Apps DBA - Part 7

Queries Arsenel for Oracle Apps DBA - Part 5

 

-- Concurrent Program with Trace Enabled

 

SELECT fcpt.user_concurrent_program_name prog_name

 

, fcp.enable_trace

 

, fcp.last_update_date

 

FROM apps.fnd_concurrent_programs fcp,

 

applsys.fnd_concurrent_programs_tl fcpt

 

WHERE NVL(fcp.enable_trace,'N') = 'Y'

 

and fcp.CONCURRENT_PROGRAM_ID = fcpt.CONCURRENT_PROGRAM_ID;

 

 

select to_char(START_TIME,'DD-MON-YYYY') Login_Time, count(*) cnt

 

from fnd_logins where START_TIME > (select to_date('15-JUN-2009 00:00:00','DD-MON-YYYY HH24:MI:SS') from dual)

 

and login_type is not null

 

and end_time is null

 

group by to_char(START_TIME,'DD-MON-YYYY');

 

 

 

 

 

select distinct d.user_name, a.START_TIME

 

from apps.fnd_logins a, v$session b, v$process c, apps.fnd_user d

 

where b.paddr = c.addr

 

and a.pid=c.pid

 

and a.spid = b.process

 

and d.user_id = a.user_id

 

and (d.user_name = 'USER_NAME' OR 1=1);

 

 

 

select user_name,to_char(last_logon_date,'DD-MON-YYYY HH24:MI:SS')

 

from apps.fnd_user

 

where to_char(last_logon_date,'DD-MON-YYYY')=to_char(sysdate,'DD-MON-YYYY');

 

 

 

 

 

--current EBS Form session

 

 

select vs.action, fft.user_form_name, vs.status session_status, vs.sid

 

From v$session vs, applsys.fnd_form ff,

 

applsys.fnd_form_tl fft

 

where vs.module like ff.form_name

 

and ff.FORM_ID = fft.form_id

 

and ff.application_id = fft.application_id

 

and vs.action like 'FRM%'

 

 

 

 

 

select oracle_username, install_group_num, read_only_flag

 

from apps.fnd_oracle_userid

 

where oracle_username = 'APPS'

 

and (install_group_num = 0 -- value should be 1

 

or read_only_flag != 'U') -- should be U

 

 

 

select oracle_id, oracle_username, read_only_flag, install_group_num

 

from fnd_oracle_userid

 

where oracle_username = 'APPS';

 

 

 

 

 

SELECT user_name

 

, TO_CHAR(last_logon_date, 'DD-Mon-YY') last_logon

 

, ENCRYPTED_USER_PASSWORD

 

, TO_CHAR(password_date, 'DD-Mon-YY') passwd_date

 

FROM apps.fnd_user

 

WHERE ENCRYPTED_USER_PASSWORD = 'INVALID'

 

AND USER_NAME IN ('SYSADMIN')

 

ORDER BY user_name