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...
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...
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...
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...
In Oracle databases, indexes become fragmented over time and cause serious performance problems. Indexes must be checked regularly and, if...
After installing Oracle clusterware, we have often asked ourselves what we named the cluster. Unless we took screenshots, of course....
When you try to import an export from a database on Exadata to a database that is not on Exadata...
