Database Blog

Oracle Database 12C release 1 (12.1)-ENCRYPTION_PWD_PROMPT=Y

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 More

Some Useful DBA Queries Related to TEMP Usage, Free Blocks, Temp tablespace groups, Block Wise Check, Free Extents, Segments etc

Some 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 More

Manual 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.

Manual 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 More

Find whether user is active or Inactive in EBS

Query 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.

— 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

— 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 More

Steps to purge the FND_OPP_AQ Table if the count reaches the threshold

Steps 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 More

Untitled

Steps to remove “DATABASE SYSTEM” target from OEM 12C The issue is after removing all the targets from a host , database system targets still appears in the oem. So…

Read More

Steps to drop a private database link

Steps 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 More

Steps to create database link in other schema

Steps 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