Free Gateway to Oracle Database (Free SQL)
For developers, students, and database enthusiasts, getting hands-on practice with a powerful database system like Oracle has often required...
March 5, 2026
ORACLE
2026
PDB Lockdown Profiles
PDB Lockdown Profiles are a security feature in Oracle’s multitenant architecture that allows administrators to restrict specific operations and features...
March 5, 2026
Oracle Flex Clusters
Oracle Flex Clusters From Oracle Grid Infrastructure 12c Release 2 (12.2) onward, all cluster configurations are implemented as Oracle Flex...
March 3, 2026
Recovery steps for OCR (Oracle Cluster Registry), voting disks, or ASM passwords in an Oracle RAC 19c
Losing OCR (Oracle Cluster Registry), voting disks, or ASM passwords in an Oracle RAC 19c environment is critical but recoverable....
February 7, 2026
2025
Oracle Globally Distributed Database
Oracle Globally Distributed Database Introduction Oracle’s 26ai release introduces a groundbreaking innovation: the Globally Distributed Database, a fully managed, horizontally scalable...
December 30, 2025
How to find chained rows in a table ?
A chained row is a row that does not fit into a single database block. For example, if you try...
December 23, 2025
DIA-49803: Purge not possible due to incompatible schema version
This error indicates that there’s a schema version mismatch between the ADRCI (Automatic Diagnostic Repository Command Interpreter) utility and the...
November 27, 2025
How to move the Oracle ASM instance password file from the file system to the disk group ?
When the password file is stored inside a disk group, it is automatically replicated across all disks in the group,...
October 16, 2025
How to recreate Grid Plug and Play ( GPnP ) profile ?
The GPnP profile is a XML file located in GRID_HOME/gpnp/<hostname>/profiles/peer under the name profile.xml. It is stored in the local...
October 14, 2025
Generating DDL script for a schema by using impdp
SQLFILE parameter in impdp can be used to generate the DDLs from a dumpfile. If you need the DDL of...
October 9, 2025
Oracle Database Feature Usage Statistics
Oracle Database includes a powerful internal mechanism called Feature Usage Statistics (FUS), which helps DBAs and system administrators track which...
April 14, 2025
SQL Tuning Health-Check Script (SQLHC)
SQL Tuning Health-Check Script (SQLHC) is used to check the environment in which a single SQL statement is running, Cost-based...
March 19, 2025
2024
Session waits on all datababase
You can display information on all database session waits by below query. SET LINESIZE 200 SET PAGESIZE 1000 COLUMN...
December 13, 2024
Execution plan fixing in Oracle databases
In some cases in Oracle databases, queries may run with bad plans due to optimizers not being able to make...
November 19, 2024
Exadata – Disk scrubbing feature
Disk scrubbing is available on Exadata cell nodes to automatically repair bad sectors on the disk when the system is...
November 19, 2024
