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 »dbtut
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-67408c9d4274c715739119/] For a specific time interval: [crayon-67408c9d42751777018864/] 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 »Using the DBMCLI Utility
DBMCLI is the command-line management tool used for the Exadata storage server to configure Exadata database servers and manage objects in the server environment. With …
Read More »How To Install Kibana On Centos
In this article I will tell the installation of Kibana on Centos 7. Before reading this article, I suggest you read the following article about …
Read More »