The wait event “logfile switch checkpoint incomplete” indicates that Oracle needs to reuse a redo log file, but the current checkpoint position is still in that log. In this scenario,…
Read MoreA user was unable to query data from tables in sql developer, the query worked fine in sqlplus and toad. Upon checking the NLS settings were different in the SQL…
Read MoreSnapshot standby is a feature in Oracle 11g that allows doing a read-write operation on the standby database. i. e we can convert the physical standby database to snapshot standby.…
Read More1. Stop your Replicat on the Target side, most likely it already abended, goto step 2. ggsci>stop replicat <name> 2. Comment out the MAP statement of that table in your…
Read MoreWhen attempting to launch Forms Builder using the command frmbld.sh in $ORACLE_INSTANCE/bin/, the following error message is displayed: $ORACLE_HOME/bin/frmbld: error while loading shared libraries: libXm.so.3: cannot open shared object file:…
Read MoreOracle GoldenGate extract and replicat processes perform checkpoint operations. In case of some unexpected failure happened, the checkpoint file or database table ensures extract and replicat processes restart’s from the…
Read MoreSQL PROFILE IN ORACLE SQL profile is a collection of additional statistical information stored in the data dictionary that helps the optimizer to generate the best plan for the query.…
Read MoreCreating sqlplan Baselines Create sql tuning set ————————- begin DBMS_SQLTUNE.CREATE_SQLSET(SQLSET_NAME => ‘&&sql_id’, DESCRIPTION => ‘SQL TUNE SET2’); END; / ——-SELECT DBMS_SQLTUNE.report_sql_monitor(type => ‘TEXT’, report_level=>’ALL’, SQL_ID=>’f2nydgpwc252s’) AS REPORT FROM DUAL; —…
Read MoreThe “Parallel Run” feature enables AutoConfig to be executed simultaneously across multiple nodes of an Oracle E-Business Suite instance. Certain AutoConfig configurations of one node depend on the configurations of…
Read MoreDiagnosing performance issues in old sessions is easy with an Oracle Database feature called Active Session History. Every second, Active Session History polls the database to identify the active sessions…
Read More