Scriprt For Finding Unusable Index :
This scripts using finding unusable index. SET VERIFY OFF LINESIZE 200 COLUMN owner FORMAT A30 COLUMN index_name FORMAT A30 COLUMN table_owner FORMAT A30 COLUMN table_name FORMAT A30 SELECT owner, …
Read MoreQuery showing unsuccessful logins for local users in E-Business Suite
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 MoreAfter Clone Concurrent Managers not coming up
When 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 MoreApex front end issue
ISSUE: 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 Morescript will list unnecessary privs in the APPLSYSPUB account
col 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 MoreEnable Diagnostics in Oracle apps for certain user.
How 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
query 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
How 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 MoreDYNAMIC SAMPLING
Introduction 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
DBMS_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 More