Convert physical standby to snapshot standby database
Snapshot 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 MoreOracle GoldenGate: Resync Single Table with Minimum Impact to Other Tables Replication
1. 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 MoreForms Builder Does not Launch on Linux RHEL5
When 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 MoreWhat is Checkpoint table in Oracle GoldenGate?
Oracle 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 MoreLife At Doyensys – G.K.VENKATESH KUMAR
Employees are the backbone of an organisation. With the right people, a company can not only achieve its goals but also surpass them. We want to thank our employees and…
Read MoreSQL PROFILE IN ORACLE
SQL 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
Creating 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 MoreRunning Autoconfig Parallel On Multiple Nodes
The “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 MorePerformance Tuning Using Active Session History
Diagnosing 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 MoreOracle 11g Resize Redo Log Size on Data Guard and Primary Database
Current Status Of Redo Logs Primary Side SQL> select group#,sum(bytes/1024/1024)”Size in MB” from v$log group by group#; GROUP# Size in MB ——- ———- 1 750 2 750 3 750 SQL>…
Read More