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.

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.

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!

Consistency check before performing RMAN resetlogs.

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

12c Wallet creation and tablespace encryption

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

Datapump Errors and Solutions

   

SCOPE

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

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.

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.

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.

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.

Object related scripts for Oracle

 

Open Resetlog Failure : ORA-00392: log 1 of thread 1 is being cleared, operation not allowed

SCOPE

Restoring the database using RMAN backup.

After completion of cloning to the staging environment, OPEN RESETLOGS fails with error as below.

ORA-00392: log 1 of thread 1 is being cleared, operation not allowed

ORA-20001: Job failed: ORA-01630: max # extents (4096) reached in temp segment in tablespace USERS

SCOPE

Application jobs fails with messages as below.

ORA-20001: Job failed

ORA-01630: max # extents (4096) reached in temp segment in tablespace USERS

ORA-00600: internal error code, arguments: [qcisSetPlsqlCtx:tzi init]

 Below document explains the issue faced after the upgrade, troubleshooting  and need for timezone files.

Oracle or PostgreSQL

 

At the point when you take a gander at PostgreSQL versus Prophet data set administration frameworks, the primary distinction between these two information bases is that PostgreSQL is an open-source data set, while Oracle is a shut data set framework.