Sometimes developers need a permission for change their login’s password. if you do not give them to necessary permission they can not change their …
Read More »dbtut
What is logging_clause On Oracle(LOGGING or NOLOGGING)
With the logging_clause parameter, we can specify whether the database objects are to be logged in the redo log when they are created, using …
Read More »role “x” cannot be dropped because some objects depend on it
If you want to delete the PostgreSQL user, we can get the error “role x can not be dropped because some objects depend on …
Read More »FORCE LOGGING On Oracle
Before you read this article, I suggest you read the article “What is logging_clause On Oracle (LOGGING or NOLOGGING)” to better understand the concept of …
Read More »SQL Server Best Practices and Configurations that need to be made After Installation
In this article, we will examine the configurations that need to be made after SQL Server Installation. You can find the details of the …
Read More »How to Restart the Oracle Database
For restart operation, we must stop and start the Oracle database. In this article we will show the below scenarios; stop an instance of …
Read More »How To Create An Operator On SQL Server
We use the operators to identify the contact list to send mail to. Right click on Operator under SQL Server Agents and call New Operator. …
Read More »Undo Advisor(OEM)
You can use Undo Advisor to set UNDO_RETENTION and the required undo tablespace size. You can open the Undo Advisor using the Database-> Diagnose-> …
Read More »How To Configure Database Mail On SQL Server
Under Management on SSMS, right click on Database Mail and select Configure Database Mail. Click “Skip this page in the future” and next. On …
Read More »Always On Availability Group Alert System
There are a few important things to check for SQL Server Always On Availability Group. Did the failover occur on any AG? Does the transfer …
Read More »