Saturday 11 November 2023

Debunking 10 Myths about Database Administrators! πŸ”₯

Database administrators (DBAs) play a critical and often underappreciated role in the world of information technology. 

Saturday 4 November 2023

A Case Study: Oracle Database vs. PostgreSQL

 Considering the best database management system for your organization? Let's explore the key differences between Oracle Database and PostgreSQL, two powerful contenders in the database landscape.

Saturday 7 October 2023

Facts: Native vs pglogical Logical Replication in PostgreSQL

Here are some of the facts about Native vs pglogical Logical Replication in PostgreSQL 

Friday 29 September 2023

Agile is NOT FAST….

Agile is a widely adopted and highly effective approach to software development and project management in the IT environment. It has gained popularity for several reasons, and its principles and practices have proven to be beneficial for many organizations. 

Monday 4 September 2023

Trace performance issues in PostgreSQL using the pg_stat_statements

πŸ‘‰ The pg_stat_statements view is a PostgreSQL extension that provides information about the execution statistics of all SQL statements that have been executed by the PostgreSQL server. 

Sunday 6 March 2022

PostgreSQL VACUUM and MVCC

   PostgreSQL uses MVCC (multi-version concurrency control) to provide transactional semantics. In the simplest form, MVCC lets each transaction work on a different copy of a row in a table. What it means is whenever a row is updated, a new version of the row is created.

Friday 4 February 2022

Tracing Oracle Data Guard

 Tracing can also be enabled in dataguard using the parameter "Log_Archive_Trace"


The values can be set using DG-Broker (if configured) or at SQL prompt as below.

Saturday 15 January 2022

Feedspot - Top database blog list


Dear All,

I am pleased to inform  that I received this recognition from Feedspot and I'm proud to be part of the awesome family- Thank you Anuj and Team for this recognition!

Saturday 8 January 2022

Consistency check before performing RMAN resetlogs.


The article covers consistency check before performing OPEN RESETLOGS after restoring a database using backup 

Saturday 18 December 2021

12c Wallet creation and tablespace encryption

The following article describes the steps to create the wallet and perform a tablepsace encryption.

Saturday 4 December 2021

Datapump Errors and Solutions

   

SCOPE

The article covers common & complex error occurs during the Datapump Export and Import operations

Friday 19 November 2021

Oracle Instance Startup Failure | Instance terminated by GEN0

  

SCOPE

Recently a server running both Oracle databases with version 11.1.0.2  had to be forced powered cycled due to a NFS issue. Since it wasn’t possible to login to the O/S to shutdown the DBs an instance recovery was required on both the 11.2 databases.

Saturday 6 November 2021

Resmgr:Cpu Quantum | Oracle wait event

 

SCOPE

Application job are running slow and DBA finds out the wait event as "Resmgr:Cpu Quantum" for multiple sessions running in database.

Sunday 17 October 2021

ASM Diskspace utilization categorized by Database/File names

SCOPE

Below script helps to identify the space utilization of Databases including the files such as Datafiles, Redologfiles, Archivelog files on ASM diskgroup categorized by Database names and their files.

Saturday 2 October 2021

ORA-12519: TNS:no appropriate service handler found (followed by ORA-00020)

SCOPE

Application complains about the error ORA-12519: TNS:no appropriate service handler found while connection to the database.