Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …
Read More »How To Check the Status of Data Pump Master and Worker Processes
You can access summary information about the status of Data Pump Master and worker processes with the following query. [crayon-6628952876ea1662260855/] You can also find out …
Read More »How To Check Whether Readable Secondary is Enabled on Availability Groups Using Policy Based Management
Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …
Read More »ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
We can receive this error in the case of many sorting or join operations in 12c databases. The reason for the error is the memory …
Read More »How To Check Availability Group Automatic Failover Settings Using Policy Based Management
Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …
Read More »“sending ioctl to a partition!” Error in System Messages in Oracle Linux
On Linux systems running Oracle database, the following error messages are displayed due to bug 17186167. The problem is fixed in version 18.1. The problem …
Read More »How To Check Availability Group’s Backup Preference Using Policy Based Management
Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …
Read More »What is the endian format in Oracle databases?
What is Endian? Endian is the storage method of multi-byte data types in memory. In other words, it determines the byte order of the data. …
Read More »How To Check Whether Availability Groups is Ready To Failover Using Policy Based Management
Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …
Read More »ORA-01017: invalid username/password error received during connection to standby database
Even if the password (orapwSID) file in the primary database is copied to the standby database side and the you can connect to the primary …
Read More »