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 »How To Check Auto Shrink Enabled Databases 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 »Find How Much Time Left For Query Completion Oracle
We can use the information in the v$session_longops view to determine the working time and the remaining time of a transaction in an active session. …
Read More »How To Check Disabled Audits 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 »How To Compress Data Pump Export
Since Oracle 11g version, Data Pump allows to compress the backup before writing to dump file with “compression” parameter. The Compression parameter takes 4 values. …
Read More »How To Check SQL Logins Without Password Policy Enforced or Password Expiration Enabled 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 »