When you create a linked server to connect to Oracle, you need to put an oracle user into the linked server. Before reading this …
Read More »
When you create a linked server to connect to Oracle, you need to put an oracle user into the linked server. Before reading this …
Read More »Stored Procedure and Function concepts in PostgreSQL are not the same as in other relational databases. Functions are used like stored procedures. In some …
Read More »With the help of the following query, you can access the answers to the questions listed below. You can filter the query as you …
Read More »Oracle stores the following components in Memory. Program Code Connected sessions even if not active Information required during Query Execution. For example, if the query …
Read More »When there is an error in a database system, the first thing we do is look at the logs. In this article, I will …
Read More »Parameter Sniffing is the result of using the query plan in the cache. When a stored procedure is compiled the last time a query …
Read More »In a Cluster you can list all the databases and their sizes withe below script. I prefer one application db for a cluster generally. …
Read More »First, We connect to the node that the database is running with ssh. We see a list of backup jobs with the following command. …
Read More »In this article we will examine how to give permission to a user in PostgreSQL. You should click on the Postgres menu item for …
Read More »First, we connect to the node where the database is located with ssh. After loading the database’s profile, we connect to RMAN with the …
Read More »