Untitled
Data dictionary corruption details – Timestamp mismatch Time stamp mismatched…
Read MoreUntitled
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 Moreexpdp 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 MoreORA-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 MoreSSD 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 Morecheck 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 MoreStart 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 MoreGet 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 MoreLast added datafile in Oracle
Below query will give you the last added datafile in oracle. This will be useful to check whenever you have datafile related issues. DBA_HIST_DATAFILE is the view stores information of…
Read More