ORACLE

The READ object privilege introduced with the 12c (12.1.0.2) version. It allows us to read a table without locking. It is used to create read-only users in databases. The difference …

Oracle Direct NFS (dNFS) is an optimized NFS client that provides faster and more scalable access to NFS storage in NAS storage devices. Direct NFS is provided as part of …

With the disable_archive_logging parameter, which is a feature introduced with Oracle 12c, we are able to import without producing redo in a database in archivelog mode. In this way, the …

There are many hidden parameters in Oracle databases. These parameters should be changed if required by Oracle. Unconscious change of these parameters can be a problem. We can learn the …

oratop is a utility that provides a general knowledge of database performance, similar to the top command in linux systems. When used with the Top command, we can get general …

During the database shutdown process, this alert is written to the alert log file because the processes of the running jobs cannot be propagated. The warning can be easily ignored. …

With a feature that introduced with 12c R2, we can see the history of Sqlplus and run the commands we have run without rewriting. By default, history is turned off. …

It is possible to forget the passwords of the users in the DB Links created for the communication between Oracle databases. These users’ passwords can be identified. You can follow …

Enable DDL Auditing in 11g It is possible to enable ddl auditing in a database or shema. In this way, we can monitor all DDL changes and we can undo …

This article describes how to change the id and name of a database that is running as RAC, what operations should be done before and after. In the examples, necessary …