Ahmet Duruöz
Losing OCR (Oracle Cluster Registry), voting disks, or ASM passwords in an Oracle RAC 19c environment is critical but recoverable....
Oracle Globally Distributed Database Introduction Oracle’s 26ai release introduces a groundbreaking innovation: the Globally Distributed Database, a fully managed, horizontally scalable...
A chained row is a row that does not fit into a single database block. For example, if you try...
This error indicates that there’s a schema version mismatch between the ADRCI (Automatic Diagnostic Repository Command Interpreter) utility and the...
Oracle Database 23ai is the latest long-term support release, and its name explicitly highlights its core focus: Artificial Intelligence. The “ai”...
When the password file is stored inside a disk group, it is automatically replicated across all disks in the group,...
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...
SQLFILE parameter in impdp can be used to generate the DDLs from a dumpfile. If you need the DDL of...
The MySQL root password provides the root user with full access to the MySQL database. If the root password is...
Oracle Database includes a powerful internal mechanism called Feature Usage Statistics (FUS), which helps DBAs and system administrators track which...
SQL Tuning Health-Check Script (SQLHC) is used to check the environment in which a single SQL statement is running, Cost-based...
To ensure the health and performance of your PostgreSQL database, you can set up a daily health check script. The...
You can display information on all database session waits by below query. SET LINESIZE 200 SET PAGESIZE 1000 COLUMN...
In some cases in Oracle databases, queries may run with bad plans due to optimizers not being able to make...
Disk scrubbing is available on Exadata cell nodes to automatically repair bad sectors on the disk when the system is...
