Author: Tarif Ahmad
-
Migrate MongoDB To CosmosDB
Pre-requisites- Steps to perform backup and restore- Step-1: Connect to the source MongoDB server and take a data dump using the mongodump utility. mongodump \ –uri=”mongodb://mongoadmin:Password@Server_IP:27017/mydocument?authSource=admin” \ –out=/root/ Step-2: Install AzCopy on Linux by using a package manager. Download the repository configuration package. curl -sSL -O https://packages.microsoft.com/config/<distribution>/<version>/packages-microsoft-prod.rpm Install the repository configuration package. sudo…
//
-
Monitoring SQL Server Deadlocks using Extended Events
Extended Events were first introduced in SQL Server 2008, and therefore you will not face any problem implementing them in our environment. Extended Events is a lightweight performance monitoring feature that enables users to collect data to monitor and troubleshoot problems. A deadlock is a situation where two or more processes or threads are blocked indefinitely,…
//
-
R-MAN BACKUP
Hi guys, in this blog I am going to explain you about R-MAN BACKUP. Archivelog : Archive log mode permits complete recovery from disk failure as well as instance failure, because all changes made to the database are permanently saved in an archived redo log. These redo log files are used with backups of your data files to…
//
-
Oracle Table Partitions
Oracle Table Partition Table partitioning in Oracle is a database feature that allows you to divide a large table into smaller, more manageable segments called partitions. Each partition is an independent unit that stores a subset of the data in the table. Partitioning is designed to improve performance, simplify data management, and enhance maintenance tasks,…
//
-
Oracle Deadlock
A deadlock in Oracle occurs when two or more transactions are blocked, each waiting for the other to release a lock. This situation creates a circular dependency where neither transaction can proceed, and the database system needs to resolve the deadlock. Oracle employs a mechanism to detect and resolve deadlocks automatically. For example, Transaction A…
//
-
Oracle Database logs
Oracle Database logs Oracle Database logs can provide valuable information about the database’s health, performance, and any issues that might have occurred. Here are several ways to check Oracle Database logs: Alert Log: The Oracle Alert Log is a primary source of information about the database. It contains messages about database startup, shutdown, errors, and…
//
-
Data Integrity
Introduction to Data Integrity It is important that data maintain data integrity, which is adherence to business rules determined by the database administrator or application developer. Business rules specify conditions and relationships that must always be true or must always be false. For example, each company defines its own policies about salaries, employee numbers, inventory tracking,…
//
-
System Views in Oracle
In Oracle Database, the concepts of “system view” typically refer to different types of views that provide access to metadata and information about the database objects. Let’s delve into each of these concepts: System Views: System views are also known as data dictionary views or catalog views. These views are part of the Oracle data…
//
-
Data file and Log File
Data file: Datafiles are physical files of the operating system that store the data of all logical structures in the database. They must be explicitly created for each tablespace. Oracle assigns each datafile two associated file numbers, an absolute file number and a relative file number, that are used to uniquely identify it. In Oracle, you can…
//
-
Resource Manager and Task Schedular-
In Oracle Database, the Resource Manager is a feature that allows you to manage and allocate resources among different users and applications. It enables you to control the number of resources (CPU, memory, and parallel execution servers) consumed by database sessions and helps in preventing runaway queries or resource-intensive operations from adversely impacting the overall…
//
-
Oracle Data Dictionary and the Dynamic Performance Views
An important part of an Oracle database is its data dictionary, which is a read-only set of tables that provides administrative metadata about the database. A data dictionary contains information such as the following: · The definitions of every schema object in the database, including default values for columns and integrity constraint information · The amount of space allocated…
//
-
Automatic Diagnostic Repository
The Automatic Diagnostic Repository (ADR) is a system-wide tracing and logging central repository for database diagnostic data. It includes the following items: Background trace files : Background trace files store information from database background processes. When a process detects an internal error, the process dumps information about the error to its trace file. Some of the information written to a…
//