DBA_HIST_SEG_STAT become invalid
Unpublished Base Bug 3603160 has been fixed in the patchset 10.2.0.3.0 For version 10.1.0.4 and version 10.1.0.5 oneoff patches exists for some platforms. Below is a list of available onoff…
Read MoreInstall oracle client via yum
CMD for Installation. yum -y -q install oracle-instantclient18.3-basic.x86_64.
Read MoreHow to Cancel the Request from the backend if frontend not helping to Cancel.
Problem: when we try to cancel a concurrent request using frontend “Cancel Request” button from the Administer > Concurrent > Manager form. We are getting the following message: “Request xxxxxx…
Read MoreADOP ERROR with Following “package body “APPS.AD_ZD_ADOP” has errors (DBD ERROR: OCIStmtExecute)”
Problem: [ERROR] Failed to execute SQL statement: select AD_ZD_ADOP.GET_INVALID_NODES() from dual [ERROR] Error Message: [ERROR] ORA-04063: package body “APPS.AD_ZD_ADOP” has errors (DBD ERROR: OCIStmtExecute) Cause: Package “APPS.AD_ZD_ADOP” is not valid…
Read MoreQuery to check the generation of all redo during the time period
Description: This query used to check the generation of all redo during the time period. Script: select to_char(begin_interval_time,'YYYY_MM_DD HH24:MI') snap_time, dhsso.object_name, sum(db_block_changes_delta) from dba_hist_seg_stat dhss, dba_hist_seg_stat_obj dhsso, dba_hist_snapshot dhs where…
Read MoreScript (.sh) scheduled in Crontab is not working
Issue: In Linux Environment, script scheduled in Crontab is not working. Impact: Not able to do any automatic healthcheck, schedule a backup etc.. in Production Database and Application. Solution: Need…
Read MoreStep by Step Oracle Database Firewall Installation on VMware
Introduction: This post is a guide to install Oracle Database Firewall 12.2.0.8 on VMware. High Level steps 1. Media Download 2. Prerequisites 3. Installation of Database Firewall 12.2.0.8 4. Post…
Read MoreTop 20 tables size by growth on user requested days.
Description: This query used to find and calculate the top 20 tables by growth for users requested days. Script: select * from (select so.owner, so.object_name, –so.subobject_name, so.object_type, so.tablespace_name, round(sum(ss.space_used_delta)/1024/1024) growth_mb…
Read MoreJob DDL
Creates the DDL for the specified job:- SET LONG 20000 LONGCHUNKSIZE 20000 PAGESIZE 0 LINESIZE 1000 FEEDBACK OFF VERIFY OFF TRIMSPOOL ON BEGIN DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'SQLTERMINATOR', true); DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'PRETTY',…
Read MoreDDL of Foreign key
Script to create foreign key DDL on all tables. SET LONG 20000 LONGCHUNKSIZE 20000 PAGESIZE 0 LINESIZE 1000 FEEDBACK OFF VERIFY OFF TRIMSPOOL ON BEGIN DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'SQLTERMINATOR', true); DBMS_METADATA.set_transform_param…
Read More