Please use the below query to generate the script and run accordingly. Public Synonym: ——————– select ‘create or replace public synonym ‘||table_name||’ for ‘||owner||’.’||table_name||’;’ from dba_tables where owner=’QA’; …
Read MorePlease run the below and do the export again. create index SYS.IMPDP_STATS_1 ON SYS.IMPDP_STATS (c5,type,c1,c2,c3,c4,statid,version);
Read MorePlease follow the below steps to delete the same. cd $ORACLE_HOME/OPatch ./opatch util listorderedinactivepatches -silent ./opatch util deleteinactivepatches -silent ./opatch util listorderedinactivepatches -silent
Read MoreIf a point-in-time recovery is not an option, follow the steps below: Backup the Database as sys user. We will have to patch fed$apps and obj$. startup restrict; Create backup…
Read MorePlease use the below query. set lines 132 col waitevent head EVENT format a5 trunc col username format a10 col osuser format a10 trunc col p1 format 9999 col…
Read MorePlease follow the below steps to delete all the latest inactive patches using the following command. One inactive patch remains, to allow the current patch to be rolled back. cd $ORACLE_HOME/OPatch . /opatch util deleteinactivepatches…
Read MorePlease use the below query. SELECT count(prev_sql_id),prev_sql_id,sql_text FROM v$session LEFT OUTER JOIN v$sql ON v$session.prev_sql_id = v$sql.sql_id WHERE status=’INACTIVE’ and machine like ‘%servername%’ HAVING COUNT(prev_sql_id)>5 GROUP BY prev_sql_id,sql_text…
Read MorePlease find the below steps to resolve the same. ADI [Application Data Integrity] memory feature is enabled by default in Solaris SPARC Download and apply Patch 35464935. OR Set the…
Read MorePlease use the below query for a period. SELECT to_char(rollup_timestamp,’DD-MON-YY HH24′) “Date”, average “CPU Usage %” FROM sysman.MGMT\$METRIC_HOURLY WHERE target_name like ‘%servername%’ AND metric_name = ‘Load’ AND metric_column =…
Read MorePlease create the below and disable or drop the trigger once completed. create or replace trigger set_trace after logon on database begin if user not in (‘SYS’,’SYSTEM’,’SYSMAN’,’OLAPSYS’) then execute…
Read More