Their are two types of vacuum in PostgreSQL – ordinary vacuum and vacuum full. In PostgreSQL dead tuple is created when you delete or update any records in a table. Normal vacuum simpl… Read More

pg_tablespace_location(oid) function is used to check the path of PostgreSQL tablespace location on disk. Tablespace in postgres is the physical location on disk where all data files related… Read More

To overcome tablespace full issue, you need to add datafile to the tablespace in Oracle otherwise you may face“ORA-01658: unable to create INITIAL extent for segment in tablespace&rdqu&hell…Read More

Test Failed: IO Error: The network Adapter could not establish the connection is very generic error which you will get while connecting via SQL Developer to the Oracle database. The resol… Read More

You might have faced this error while creating or deleting staza in pgBackrest. I got this error while creating stanza as shown below: bash-4.4$ pgbackrest stanza-create --stanza=db … Read More

bash-4.2$ pg_restore -U appmdm-Ft -d test pg_restore: error: corrupt tar header found in PGDMP (expected 0, computed 18703) file position 512 The above error occurred while importing the… Read More

Only postgres user or superuser can grant CREATEROLE permission to a user or role in postgres. If you don’t have this permission, you will get ERROR: permission denied to create role… Read More

When an instance is started, Oracle Database allocates a memory area called the system global area (SGA) and starts one or more background processes. Types of Processes: Different type… Read More

It is easy to modify AWS RDS instance class using AWS console but in this post we will discuss about changing instance type using AWS CLI. It is always recommended to test Instance class upg… Read More

You cannot use the “alter system kill session” command to terminate blocking sessions in RDS Oracle instead of that you need to use rdsadmin.rdsadmin_util.kill procedure to kill… Read More

In Aurora, data is stored in cluster volume and the shared storage architecture makes your data independent from the DB instances in the cluster. So if you have deleted the instance in Auror… Read More

You might have encountered AWS RDS storage full situation for your RDS instance. To overcome this situation you can increase or scale up the storage using Amazon RDS console or else using th… Read More

No space left on device error is very common in Amazon Aurora for PostgreSQL which mainly occurs when local storage is exhausted on the DB instance due to which processes could not write… Read More

Truncate remove all records from a table and it is much faster than delete operations. Users generally ask, how to delete all records from a table to load fresh data into it? Which is f… Read More

I faced this issue on MAC when I was trying to connect to vpn using Cisco AnyConnect. The error message was: “The VPN client was unable to successfully verify the IP forwarding tabl… Read More

In this PostgreSQL tutorial, we will discuss about connection details like, max connections, active / inactive connections, kill sessions, increase max connections in PostgreSQL. How to… Read More

In previous PostgreSQL tutorial we discussed about enabling archive in postgres, here will discuss about PostgreSQL connection details to list number of connections active on the database… Read More

In this PostgreSQL tutorial, we will discuss about enabling WAL Archiving in PostgreSQL. WAL is short for Write Ahead Log. You must enable archive mode in PostgreSQL for PITR. In short… Read More

In this post we will discuss about ADOP online patching method which was introduced in Oracle EBS R12.2. It has different phases which help us to apply the patch with minimum downtime using… Read More

You can use simple SQLPlus query to find the version of Oracle E-Business Suite. Recently the latest Oracle EBS version R12.2.10 has been released to download as a patch. If you are plann… Read More

Postgres update database version at regular intervals. Major PostgreSQL version is released every year and minor versions are released at least once every three months. Each major versio… Read More

You must be familiar with checking tablespace utilization in Oracle 11g, here we will discuss about monitoring tablespace in CDB and PDB. Oracle introduced multitenant architecture from… Read More

A very simple way to rename table in PostgreSQL is using alter table statement. While changing table name you would be thinking about what will happen to indexes and other constraints on the… Read More