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 …
Read More »
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 …
Read More »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 …
Read 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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 »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 …
Read More »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 »