set pagesize 1000 set linesize 200 select u.user_name, ful.user_id, to_char(attempt_time,’DD-MON-RRRR HH24:MI:SS’) attempt_time from fnd_unsuccessful_logins ful, fnd_user u where ful.user_id = u.user_id (+) order by attempt_time;
Read MoreWhen cloned my DEV instance last time, I have an issue with concurrent manager not coming up using Finally decided to stop the concurrent manager using $ADMIN_SCRIPTS_HOME . adcmctl.sh stop…
Read MoreISSUE: After installing apex front end is not opening SOLUTION: This is because dispatchers parameter hasn’t set. STEPS: SQL> select value from v$parameter where name = ‘dispatchers’; VALUE ——————————————————————————– SQL>…
Read Morecol GRANTOR format a24 col PRIVILEGE format a14 col TABLE_NAME format a32 select GRANTOR,PRIVILEGE, TABLE_NAME from DBA_TAB_PRIVS where grantee = ‘APPLSYSPUB’ and privilege in (‘SELECT’,’INSERT’,’EXECUTE’,’DELETE’) and…
Read MoreHow to enable Oracle apps Diagnostics-> Examine, for certain users? Steps 1 Navigate to System Administrator responsibility> Profile> System> Steps 2 Enter profile name: Utilities:Diagnostics Enter Application User for whom…
Read Morequery to find all the select statement which is using Full Table Scan SELECT SQL_ID,OPERATION,OPTIONS,OBJECT_NAME,OBJECT_OWNER FROM V$SQL_PLAN WHERE OPTION like ‘%FULL%’ AND OPERATION like ‘%TABLE%’; –Then find the Query Text…
Read MoreHow many users per application in Backend select application_name, count(user_name) from (SELECT fu.user_name, application_name, count(application_name) FROM fnd_responsibility_tl t, …
Read MoreIntroduction Oracle Database introduced Dynamic Sampling to allow the optimizer to gather additional information at parse time. If database statistics were missing, stale or insufficient to produce a good execution…
Read MoreDBMS_SCHEDULER in Oracle Database Scheduler in the Oracle Database is done by DBMS_SCHEDULER package. This package can be used to create different types of jobs :- 1. Jobs having Program…
Read MoreDATAGUARD MONITORING ==================== Check DB role(PRIMARY/STANDBY): ================================ SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE; Monitor standby background process: =================================== SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM…
Read More