Archive for the ‘ORACLE Database’ Category

Oracle Database Recovery Manager (RMAN) – how many channels you can allocate

Freitag, August 22nd, 2025

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

Oracle Database AutoUpgrade 25.3 – is designed to automate the upgrade process both before starting upgrades during upgrade deployments and during postupgrade checks and configuration migration

Donnerstag, August 21st, 2025

Oracle Database Recovery Manager (RMAN) – for encrypted backups you need a license for the Oracle Advanced Security option

Freitag, August 1st, 2025

Split Brain Syndrome – in a Oracle RAC environment all the instances/servers communicate with each other using high speed interconnects on the private network

Montag, März 24th, 2025

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 GoldenGate Studio Free – deploys from a Docker container onto laptops on-premises or any cloud

Montag, März 17th, 2025

Oracle Database 19c Enterprise Edition – Premier Support (PS) ends December 31, 2029 and the Extended Support (ES) will be Jan 01, 2030 through December 31, 2032

Donnerstag, Februar 20th, 2025

Oracle Database 19c – offers powerful commands to manage the storage space of tables efficiently among these commands are the ‚ENABLE ROW MOVEMENT‘ ‚SHRINK SPACE‘ and ‚CASCADE‘ options

Freitag, Februar 14th, 2025

Oracle – what is a Vector Database and how can it help meet business needs

Samstag, November 23rd, 2024

Oracle Database 23ai – damit werden Spitzentechnologien wie maschinelles Lernen (ML) künstliche Intelligenz (KI) und generative KI bereitgestellt um datengesteuerte Entscheidungen zu verbessern

Mittwoch, September 4th, 2024

Oracle Database 23ai – sets new industry standard for a modern AI database

Samstag, August 24th, 2024

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

Oracle Database – how to create a ‚Public Database Link‘ or a „Private Database Link‘

Samstag, Januar 20th, 2024

Oracle Database – how to get information with ChatGPT about the size of Oracle CLOB or BLOB columns can be obtained using the DBMS_LOB.GETLENGTH function the result is the length of a LOB (Large Object) value in bytes

Mittwoch, Januar 17th, 2024
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;

Oracle Database – Partitioning

Donnerstag, Januar 4th, 2024

Oracle Database – Advanced Compression

Donnerstag, Januar 4th, 2024

Oracle Database – Security

Donnerstag, Januar 4th, 2024