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 …
Read More »
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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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. …
Read More »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. …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »