How To Unset DB_FILE_MULTIBLOCK_READ_COUNT to Default Value in Oracle Database
Question: DB_FILE_MULTIBLOCK_READ_COUNT is set to 16 in the spfile. How to unset the parameter as it keeps reverting back to the default value?
Question: DB_FILE_MULTIBLOCK_READ_COUNT is set to 16 in the spfile. How to unset the parameter as it keeps reverting back to the default value?
There are two kinds of initialization parameters: Dynamic initialization parameters can be changed for the current …
The goal of this post is to provide steps to add, remove, replace or move an Oracle Cluster Repository (OCR) and/or …
It is not possible to directly restore a manual or automatic OCR backup if the OCR is located in an ASM disk group.
The script provided below will report On Space Usage in Tablespaces. Access Privileges required: SELECT on …
MySQL Replication Replication in MySQL copies changes from one server―the master―to one or more slaves. The master …
If you are into systems, you would’ve heard about backups. I think in all fields backup is one thing which is of …
Triggers are named database objects that activate when you modify table data. They can: Examine data before it is …
MySQL Events are tasks that run according to a schedule. They can be referred to as “scheduled events.” When you create …
Exporting and Importing Data The two most common ways to accomplish export and import operations are: Using SELECT …
Stored Routines A stored routine is a named set of SQL statements that are stored on the server. Clients do not need to …