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 »ORA-27104: system-defined limits for shared memory was misconfigured
In the Oracle 12c version, during database creation with dbca, this error is received because the shmall kernel parameter is not set correctly. The problem …
Read More »How To Check VLF Counts in the 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 »What is ASM Failure Group
ASM Failure group is defined as protection against the problems in disk in ASM disk groups. Oracle provides disk redundancy with failure groups. If the …
Read More »How To Check Stored Procedure Names Using Policy Based Management(RegEx)
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 »Cannot communicate with crsd
In Oracle RAC databases, for cluster operations, errors can be received because the crsd process is stopped or suspended. In this case, it should check …
Read More »How To Check Recovery Model of All 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 »