In some cases in Oracle databases, the optimizer may make the wrong decision and cause this query to run with the wrong query plan. If …

In this article we will create a simple dashboard with Kibana. First we need to connect to Kibana and create an Index pattern. For more …

In this article, we will move a csv file we created, to elasticsearch with logstash. You can also move TXT files to elasticsearch in the …

Since SQL Server 2008, we can debug our TSQL queries as in Visual Studio. In this way, we can see which variable gets what value …

ADRCI (ADR Command Interpreter) can be used to display errors in services such as Oracle database, grid, asm, listener. In all ADRCI-defined homes, you can …

Each database administrator wants to detect and delete unused logins. By default in SQL Server, the last time the login was logged is not stored …

To move all objects in a schema to a different schema, the following steps must be followed. The following queries prepare the queries required for …

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 …

During the 12c database creation process , you can see ORA-20001 error in the alert log file when the “SYS.ORA $ AT_OS_OPT_SY_ <NN>” auto job …

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 …