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 Memory Components(SGA and PGA)
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 »Where is the Log File In PostgreSQL
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 »What is Paramater Sniffing
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 »How To Get Size Of All Tables And Database On PostgreSQL
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 »How To Run Backup Job Manually On Oracle
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 »How To Give Permission To a User On PostgreSQL
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 »How To Change Backup Retention AND Delete Obsolete Backup On RMAN
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 »Sp(Stored Procedure) On SQL Server
You can keep the database-level code that you need to use every time in the application through “stored procedures” in the database. You can …
Read More »How To List Active Queries On PostgreSQL
In this article I will explain you to list active queries in postgresql. First you must connect to postgresql. You may want to read …
Read More »