Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

Problem: When attempting to pull data from sql server with db link in Oracle database, ORA-600 error occurs. Reason: Setting the cursor_sharing parameter to force …

  When using dblink in Oracle 11.2.04, we get ORA-04052 error when we want to create an object with the query result from dblink. To …

  I have already mentioned how to create a linked server that will connect to Oracle in the article named “How To Create a Linked …

  When you create a linked server to connect to Oracle, you need to put an oracle user into the linked server. Before reading this …

  Stored Procedure and Function concepts in PostgreSQL are not the same as in other relational databases. Functions are used like stored procedures. In some …

  With the help of the following query, you can access the answers to the questions listed below. You can filter the query as you …

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 …

  When there is an error in a database system, the first thing we do is look at the logs. In this article, I will …

  Parameter Sniffing is the result of using the query plan in the cache. When a stored procedure is compiled the last time a query …

  In a Cluster you can list all the databases and their sizes withe below script. I prefer one application db for a cluster generally. …