IT Solutions Technology Blog

The optimal number of RMAN channels depends on the number of CPU cores physical I/O devices (disks tape drives) and the specific task but a good starting point is to match the number of channels to your physical output devices or to 1-2 less than your total CPU cores to leave resources for the operating system

Split Brain Syndrome – this private network interface or interconnect are redundant and are only used for inter-instance oracle data block transfers. Now talking about split brain concept with respect to oracle RAC systems it occurs when the instance members in a RAC fail to ping/connect to each other via this private interconnect but the servers are all physically up and running and the database instance on each of these servers is also running

Simple Majority Rule according to Oracle “An absolute majority of voting disks configured (more than half) must be available and responsive at all times for Oracle Clusterware to operate” which means to survive from loss of ‘N’ voting disks you must configure at least ‘2N+1′ voting disks. Now we are in a state to understand the use of voting disk in case of heartbeat failure

Oracle Database 23ai (for Free) – offers the ability to experience Oracle Database which businesses throughout the world rely on for their mission critical workloads the resource limits for Oracle Database (for Free) are up to 2 CPUs for foreground processes 2 GB of RAM and 12 GB of user data on disk and it is packaged for ease of use and simple download

SELECT DBMS_LOB.GETLENGTH(your_clob_column) AS clob_size
FROM your_table
WHERE your_condition;

SELECT DBMS_LOB.GETLENGTH(your_blob_column) AS blob_size
FROM your_table
WHERE your_condition;