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 MoreTimeout 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 MoreI 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 MoreDuring 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— 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 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 MoreGet 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 MoreSometime 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