What is Smart Scan in Oracle Exadata
It’s a feature that can be used with Exadata. Exadata is capable of offloading a large portion of a query’s workload to the storage cells. So how it works? Smart…
Read MoreRoCE in Exadata X8M
Oracle Exadata Database Machine X8M is on the way! Building on the Exadata X8 state-of-the-art hardware and software, the Exadata X8M family adopts two new cutting-edge technologies: RDMA over Converged…
Read MoreExadata Cell software components
In this article, let us go through the Exadata Storage Cell Processes (MS, RS and Cellsrv). There are three main Exadata Storage Cell Processes: Cell Services (cellsrv) Cell Services (cellsrv)…
Read MoreOracle ORA-21561 : OID generation failed
Solution: Then the problem is most likely in the machine hosts file. Check that there is machine full name and short name in the machine hosts file. If these are…
Read MoreDatabase spending most of the time in wait event “log file switch (checkpoint incomplete) Waits event”
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 MoreUsers unable to query in SQL Developer
A 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 MoreConvert 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 More