Posts by Doyensys

ORA-15067: command or option incompatible with diskgroup redundancy

When dropping an online disk from a diskgroup why is ORA-15067 error returned? SQL> alter diskgroup data01 drop disk data01_01; alter diskgroup data01 drop disk data01_01 * ERROR at line…

Read More

Untitled

                                         Data dictionary corruption details – Timestamp mismatch Time stamp mismatched…

Read More

Untitled

Timeout Error Encountered for pasteBinary.sh While Running “adop phase=fs_clone” While running fs_clone phase in 12.2.2, we have faced  the following issue. Error: Enabling EBS_LOGON trigger Error while executing [filesystem]/fs2/inst/apps/[context_name]/appltmp/alter_ebs_logon_trigger.sql Failed to…

Read More

expdp job still executing even after killed from OS level

I killed a expdp job from OS level but I saw that the job still executing. I started the job as background like below: $ nohup expdp “/ as sysdba”…

Read More

ORA-20005: object statistics are locked (stattype = ALL) – Solution

During tuning a query, I found one table has stale statistics. While running gather stats for that table, got below error. Let me demonstrate with a demo table: SQL> execute…

Read More

SSD script

— Find segments with most read operations, and hopefully relatively few writes — These are good candidates for placing on SSD storage WITH segment_stats           AS…

Read More

check and kill

— Check what the sessions in our instance are waiting for select event,count(*) from v$session group by event order by count(*); — Flexible query to check what’s currently running in…

Read More

TFSCLOCK

SET ECHO off REM NAME:   TFSCLOCK.SQL REM USAGE:”@path/tfsclock” REM ———————————————————————— REM REQUIREMENTS: REM    SELECT on V_$LOCK, V_$SESSION, SYS.USER$, SYS.OBJ$ REM ———————————————————————— REM PURPOSE: REM    The following locking information…

Read More

Start workflow services from backend

Get the component id from below command col component_name for a20; col COMPONENT_STATUS for a20; select COMPONENT_NAME, COMPONENT_STATUS,Component_Id from fnd_svc_components; To start the services from back end – connect to…

Read More

Get standard view definition details

Sometime you wonder about the standard oracle views that where it gets information.  Also, you might be interested in getting base table information so that you can write your own…

Read More