Dear Readers, In this article, we will see GoldenGate 12c setup for Oracle Container Database. Separate user for Extract and Replication need to be created. User for Extract should be common user connected to Root Container in order to interact with the logmining server. For… Read More
Group Replication in MySQL: MySQL Group Replication and how to install, configure and monitor groups. MySQL Group Replication enables you to create elastic, highly-available, fault-tolerant replication topologies. MySQL Group Replication is a MySQL Server plugin that provides distributed state machine replication with strong coordination between… Read More
Dear Readers, In this article, we will see the following Master Slave Configuration in Jenkins. Steps to Follow : Master Server:👉Launch Master Server👉Install Jenkins Slave Server:👉Launch Slave Server👉Create SSH Password Authentication 👉Install java👉Generate SSH Key👉Move the Public SSH Key to Authorized keys👉Give Permission to the Authorized keys… Read More
Dear Readers, In this article, we will see UNDO segments not Releasing Space . UNDERSTANDING: There are three status of UNDO segments: ACTIVE: Currently in Used EXPIRED: Extend cannot be Used UNEXPIRED: unexpired extents were reused The UNDO records are not deleted when they are… Read More
Dear Readers, In this article, we will see Performance Investigation(Database / SQL) . UNDERSTANDING: Database running slow or application running slow. These are the basic and practical issue come in day today activity. Before Investigation have below answers from application or client or users 👉… Read More
Dear Readers, In this article, we will see MySQL Identifying unused indexes. Identifying unused indexes: MySQL doesn’t provide completely reliable options to get the accurate index usage details. Below listed are the some of the options available and some of the options are version specific… Read More
Dear Readers, In this article, we will see DB scattered Read Wait Event. DB scattered Read wait event Adjacent blocks are read from disk allowing Oracle to read many blocks by performing large I/Os. Thus, from the storage perspective, db file scattered read is a… Read More
Dear Readers, In this article, we will see Direct Path ReadWait Event. Direct Path Read Wait event: The Direct Path Read Temp wait events are an access path in which multiple Oracle blocks are read directly to the Oracle process memory without being read into… Read More
Dear Readers, In this article, we will see AWR Customization . AWR Customization: Oracle init parameter “statistics_level” enables AWR to collect and maintain performance data. Values for parameter are :: BASIC : Doesn’t collect AWR or any metric stats TYPICAL: (Default), Collects typical advisories and… Read More
Dear Readers, In this article, we will see Installation and Configuration of GoldenGate 19C on Oracle RAC . Source: 2-Node RAC Oracle 19c Database Source Server has a NFS Drive: /goldengate Target: Oracle 19c Database Plan: Install GoldenGate on both the machine and a soft… Read More
Dear Readers, In this article, we will see Oracle 18c New Features for DBA’s . Oracle 18c New Features for DBA’s Manual Termination of run-away queries A new command is introduced for DBAs to cancel blocking or too expensive statements instead of kill the originating… Read More
Dear Readers, In this article, we will see Kill blocking sessions in RAC . Kill blocking sessions in RAC: set serveroutput on set feedback off set linesize 300 declare blockcount number; sqlreport varchar(3000); sqloutput varchar(5000); v_rec varchar(3000); cursor blk_curs is select B.USERNAME BUSER,B.SID BSID,B.SERIAL# BSERIAL,B.INST_ID… Read More
Dear Readers, In this article, we will see the following Comparison between Python and Shell Script for sending email for the set of SQL commands. Python and Shell Script for sending email for the set of SQL commands: Shell Script: #!/bin/bash #Script to perform testing… Read More
Dear Readers, In this article, we will see the following Top CPU & ELAPSED Queries. Top CPU Queries : select * from (SELECT dhst.sql_id,SQL_TEXT,X.CPU_TIME/1000000 CPU_Time_inSec,X.Num_Execs,round(((X.CPU_TIME/1000000)/X.Num_Execs),3) CPUPEREXEC, X.num_rows FROM DBA_HIST_SQLTEXT DHST, (SELECT DHSS.SQL_ID SQL_ID,SUM(DHSS.CPU_TIME_DELTA) CPU_TIME ,sum(executions_delta) as Num_Execs,sum(ROWS_PROCESSED_delta) as num_rows FROM DBA_HIST_SQLSTAT DHSS WHERE DHSS.SNAP_ID IN(SELECT… Read More
Dear Readers, In this article, we will see the following Create Amazon Linux EC2 Instance in AWS CLI. Steps to Follow : Connect to AWS CLI On Windows Create a Key Pair Create a Security Group Create a Amazon EC2 Instance Create a Volume Attach… Read More
Dear Readers, In this article, we will see the following Install Jenkins On Ubuntu. Steps to Follow : Logging to AWS Account Launch Ubuntu EC2 Instance Connect to Linux EC2 Instance by Using Putty Install the Java Package Configure the Java Home Location Download and… Read More
Dear Readers, In this article, we will see the following Configure SSH Password Authentication For Amazon EC2 Instance . Steps to Follow : Logging to AWS Account Launch Linux Server Connect to Linux EC2 Instance by Using Putty Enable SSH Password Authentication Connect to Linux… Read More
Dear Readers, In this article, we will see the following Connect to Amazon EC2 Instance Using Putty. Steps to Follow : Logging to AWS Account Launch Linux Server Download putty and puttygen tools Convert pem file to ppk file by using puttygen Connect to Linux… Read More
Dear Readers, In this article, we will see the following Connect to Amazon EC2 Instance Using Putty. What is AWS CLI? The AWS CLI is a unified tool to manage your AWS services from a terminal session on your own client. With just one tool… Read More
Dear Readers, In this article, we will see the following Realtime Usecase. Realtime Usecase : My Client wants to launch their Websites publicly along with its Database Servers at the back end. Establish network connectivity between Web Servers & Database Servers. Note: No need of… Read More
