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
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
In which cases , indexes should be rebuild ?
In Oracle databases, indexes become fragmented over time and cause serious performance problems. Indexes must be checked regularly and, if...
November 19, 2024
PostgreSQL Security Vulnerabilities
You can find more detailed information about a security vulnerability by clicking on the links in the table below. Known...
November 16, 2024
How to query cluster name?
After installing Oracle clusterware, we have often asked ourselves what we named the cluster. Unless we took screenshots, of course....
November 8, 2024
ORA-64307: Exadata Hybrid Columnar Compression is not supported for tablespaces on this storage type
When you try to import an export from a database on Exadata to a database that is not on Exadata...
November 8, 2024
How to resize ACFS file system online ?
We can resize the ACFS file system online without having to umount or disable volume. For this, we use the acfsutil tool....
November 8, 2024
How to convert Administrator-Managed databases to Policy-Managed databases ?
The cluster database configuration can be Policy-Managed or Administrator-Managed. A Policy-Managed database has instances managed on a per-server pool basis...
November 8, 2024
Oracle Flashback Query
Oracle Flashback Query allows the use of select query with AS OF. It allows us to query as much of...
November 8, 2024
How to fix poor performance issues on Exadata cellnode flash disks without replacement?
Exadata cellnode flash disks can sometimes have poor performance. If the error numbers are 0 (zero) or very low when...
November 8, 2024
Goldengate “Not enough database memory” issue
If Goldengate extract services fail to start with errors such as the ones below, the solution is very easy. Possible...
November 8, 2024
Oracle 12c IDENTITY Columns & Default SEQUENCES
I will try to explain the identity field, which is my favorite innovation in Oracle 12c. MS SQL, MYSQL users...
November 8, 2024
How to reconfigure Grid Infrastructure components?
If you cloned an existing server as another server and the ASM disks and all files are moved but ohas...
November 8, 2024
How to fix corrupt UNDO tablespace ?
If the Oracle UNDO tablespace is corrupted, it is possible to receive errors such as the one below. ORA-00376: file...
November 8, 2024
