Query To Find Dependent Objects Of An Invalid Object
SELECT owner, object_type, object_name FROM dba_objects WHERE status = ‘INVALID’ AND object_name IN (SELECT referenced_name FROM dba_dependencies WHERE name = ‘<INVALID_OBJECT_NAME>’);
Read MoreQuery to Check locks on a table
Select object_id, session_id, oracle_username, os_user_name, Process, locked_mode From sys.v_$locked_object; Select a.object_name, b.oracle_username From all_objects a, v$locked_object b Where a.object_id = b.object_id And a.object_name like ‘po%’;
Read MoreSupport date for Oracle WebLogic Server versions
The following table provides the date each version was released and its end of Grace Period. These are dependent on a Patch Set released in order for the Grace Period…
Read MoreOID EMAGENT not started once after Daylight Savings
Once after Daylight saving happened, Some of the IAM & IDM management service was down. So we thought of bouncing the complete SSO services. While starting IDM services EMAGENT was…
Read MoreOpmnctl Process Hangs During Installation and Cloning Due to a Bug in the Opmnctl Script
Environment: Oracle Fusion Middleware - Version 10.1.3.1.0 to 10.1.3.3.0 [Release AS10gR3] Symptoms: The opmnctl process hangs and goes into a loop, executing opmnctl repeatedly and thereby increasing the number of…
Read MoreOracle 19c Database Upgrade From 11.2.0.4 to 19.0.0.0 Using DBUA
Description:- There are different ways of upgrading to the latest release of Oracle database and Oracle provides multiple methods to upgrade. Few are listed below: Database Upgrade Assistant (DBUA) Manual…
Read MoreCould not initialize the Service Manager FNDSM__ Verify that has been registered for concurrent processing
Cause The issued was found to have been caused by the FND_NODES table having incorrect node entries (old node from the source instance) and that no Service Manager was found…
Read MoreSQL Profiles & Baselines
To check SQL Profile : select NAME,SIGNATURE ,STATUS,FORCE_MATCHING from dba_sql_profiles; ENABLE/DISABLE/DROP EXEC DBMS_SQLTUNE.ALTER_SQL_PROFILE(‘coe_5273fz2cqkk80_3455548535′,’STATUS’,’DISABLED’); exec dbms_sqltune.drop_sql_profile(‘coe_5273fz2cqkk80_3455548535’); SQL Profiles for a sql_id set lines 1000 pages 9999 col name for a30 col…
Read MoreScripts to identify performance related issues.
one script to Identify all performace issue related to sql query Set echo off set trimspool on set define on column filename new_val filename select to_char(sysdate, ‘yyyymmdd-hh-mi-ss’ ) filename from…
Read MoreUndo related queries
Undo Related Queries To check retention guarantee for undo tablespace select tablespace_name,status,contents,logging,retention from dba_tablespaces where tablespace_name like ‘%UNDO%’; To show ACTIVE/EXPIRED/UNEXPIRED Extents of Undo Tablespace select tablespace_name, status, count(extent_id) “Extent…
Read More