Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
If access to cellnodes with voting files is not available, relocation errors can be received as follows, even if access is possible later. This error …
Read More »
How To Install Search Guard For Elasticsearch and Kibana
We can manage Elasticsearch Indices seperatly in one cluster using Search Guard instead of Xpack. Because Search Guard is free. In this article, we will …
Read More »
How To Find Oracle Database Memory Usage(SGA and PGA)
The following query can be used to determine the memory usage rates in Oracle databases. If there is an increase in the memory values from …
Read More »
How To Create an Elasticsearch Indice(Index) using Kibana
Before reading this article, you may want to read the following article to learn the concepts related to Elasticsearch. “What is Elasticsearch” We determine the …
Read More »
How To Find Current Open Cursors in Oracle
In Oracle, you can find the open cursors with the following query. The following error occurs when the number of open cursors reaches the open_cursors …
Read More »
How To Monitor Elasticsearch Nodes, Indices and Shards Using Kibana
We can monitor Nodes, Indices and Shards in Elasticsearch using Kibana. Connect to Kibana and click Monitoring. You may want to read the following articles …
Read More »
How To Find Last Refresh Time of Materialized Views
The following queries can be used to determine when materialized views were last refreshed. For all times: [crayon-6741317161739280210506/] For a specific time interval: [crayon-674131716173e235004140/] or …
Read More »
Search a Keyword in Elasticsearch using Kibana
We mentioned that Elasticsearch is a search engine in the article “What is Elasticsearch“. Searching for a keyword in Elasticsearch is very fast. In this …
Read More »
Setting Thresholds for metrics on Exadata Database Servers Using DBMCLI
On Exadata database servers, it is also possible to set thresholds for metrics and send notifications when they reach these threshold values. With DBMCLI, we …
Read More »
What is Elasticsearch
In this article we will talk about the basic concepts of Elasticsearch. I recommend that you read the following articles to create Elasticsearch on Centos …
Read More »