There is new option to pass in silent mode encryption password in Oracle 12C during exporting sensitive data. In new version user is asked about password during execution of export.…
Read MoreSome Useful DBA Queries Related to TEMP Usage, Free Blocks, Temp tablespace groups, Block Wise Check, Free Extents, Segments etc.. To check instance-wise total allocated, total used TEMP for both…
Read MoreManual Method to generate Output files(PDF,EXCEL,TXT,HTML) Using BI-Publisher Desktop in EBS When OPP fails or not able to generate Out for some Concurrent Programs. 1) Download the Oracle BI Publisher…
Read MoreQuery to Find whether user is active or Inactive in EBS SQL : SELECT ‘Active’, valid.* FROM fnd_user valid WHERE valid.user_id IN (SELECT user_id FROM fnd_user WHERE NVL (end_date, SYSDATE) >= SYSDATE) UNION…
Read More— Script to get SQL ID which has more than one plan hash value. — This is for last 7 days data from sysdate, SET SERVEROUTPUT ON DECLARE v_count…
Read More— Script to find Invalid objects list with Error details set lines 170 set pages 10000 col owner format a20 col TEXT format a100 col NAME format a30 col LINE format…
Read MoreSteps to purge the FND_OPP_AQ Table if the count reaches the threshold 1) Bring down the Application services before performing this activity 2) Reboot the database once. $ sqlplus /…
Read MoreSteps to drop a private database link Below is a step to drop a private database link. As sys user create the following procedure under the schema from which database…
Read MoreSteps to create db link in other schema Below is a method to create private database link in other schema As sys user create the following procedure under the schema…
Read More