Streaming replication in PostgreSQL is a vital feature for ensuring data availability and redundancy. Once your primary and standby servers are set up, it’s essential to monitor the [...]

PostgreSQL’s streaming replication is a powerful feature that allows real-time data replication from a primary database server (master) to one or more standby servers (slaves). This guide [...]

                                                                                                Logrotate  logrotate is a utility for managing […]

  INTRODUCTION:  This doc will guide you through the process of installing Postgresql14, Pgadmin4 and also Creating users, databases, schemas VERSION: PostgreSQL14 PGAdmin-4 Verify Platform [...]

what is psudocolumn, Rowdepandancy and Norowdepandency in oracle   A pseudocolumn behaves like a table column, but is not actually stored in the table. You can select from pseudocolumns, but you [...]

All Redo log group Members are in active state, ORA-20 max number of processes exceeded, Database went hung state After restart  A) All Redo log group Members all are in active state   If the [...]

CLOB and BLOB are two types of data types used in databases to store large amounts of data. [...]

Oracle index is a database object that is used to improve the performance of certain queries by providing direct access to the data in a table.  [...]

1.For Loading jar use cmd loadjava -force -genmissing -r -user username/password@servicename -verbose jar     2.For droping jar use cmd   dropjava -f -verbose -u [...]

Query:   select s.sid,sn.SERIAL#,n.name, round(value/1024/1024,2) redo_mb, sn.username,sn.status,substr (sn.code1,1,21) “code”, sn.type, sn.module,sn.sql_id from v$sesstat s join [...]