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?
Latest Articles
How to View and Set Dynamic and Static Oracle Database Parameters
There are two kinds of initialization parameters: Dynamic initialization parameters can be changed for the current …
How to Add, Remove, Replace or Move an Oracle Cluster Repository (OCR) and/or Voting Disk in Oracle Clusterware
The goal of this post is to provide steps to add, remove, replace or move an Oracle Cluster Repository (OCR) and/or …
How to Restore ASM Based OCR After Complete Loss of the CRS Diskgroup on Linux
It is not possible to directly restore a manual or automatic OCR backup if the OCR is located in an ASM disk group.
SQL Script to Report on Space in Tablespaces in Oracle Database
The script provided below will report On Space Usage in Tablespaces. Access Privileges required: SELECT on …
Beginners Guide to MySQL Replication
MySQL Replication Replication in MySQL copies changes from one server―the master―to one or more slaves. The master …
Beginners Guide to MySQL Backup and Recovery
If you are into systems, you would’ve heard about backups. I think in all fields backup is one thing which is of …
How to Create and Execute Triggers in MySQL
Triggers are named database objects that activate when you modify table data. They can: Examine data before it is …
How to Create, Alter, and Drop Events in MySQL
MySQL Events are tasks that run according to a schedule. They can be referred to as “scheduled events.” When you create …
Beginners Guide to Exporting and Importing Data in MySQL
Exporting and Importing Data The two most common ways to accomplish export and import operations are: Using SELECT …
How to Create and Execute Stored Routines in MySQL
Stored Routines A stored routine is a named set of SQL statements that are stored on the server. Clients do not need to …