The DBA_HIST_ACTIVE_SESS_HISTORY data dictionary view can be used to find queries executed in the Oracle database. Historical information is available. You can use the V$ACTIVE_SESSION_HISTORY …
Read More »Update Your Database with Upgrade Data-tier Application
Before you read this article, I recommend that you read the article “What is Data-Tier Application” to avoid confusion. In the article I mentioned above, …
Read More »How To Find Process Informations of a Session(Kill Oracle Session)
You can access the process information of a session in the Oracle database with the following query. Sometimes it is not possible to terminate a …
Read More »What is Data-Tier Application
Data-Tier Application Version 1.1 (DAC) was introduced with SQL Server 2008 R2. With Data-Tier Application, we are able to transfer the databases of our applications …
Read More »Profile password verify function issue(FROM ROOT)
Even if the password_verify_function limit of a profile is changed in Oracle databases, it does not change as requested and changes to “FROM ROOT”. The …
Read More »What is SQL Server IntelliSense
IntelliSense was introduced with SQL Server 2008. With this feature, we can now write TSQL Code in a more practical way. So where can we …
Read More »How To Fix The SQL Plan in Oracle Databases
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 »How To Visualize Data with Kibana(Create a Dashboard with Kibana)
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 »How To Move CSV or TXT to Elasticsearch
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 »How To Debug TSQL Queries
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 »