Daily Tips for MySQL
Dear Readers, In this article, we will see the following Daily Tips for MySQL . Tip-1 Date: 30-Nov-20 Provided By (Linkedin) : Srinivas 👉 In MySQL Replication Master can be ib RHEL and Slave can be on… Read More
Page 27
Daily Tips for SQL Server
Dear Readers, In this article, we will see the following Daily Tips for MySQL . Tip-1 Date: 30-Nov-20 Provided By: Sridhar SQL Server is a platform dependent (windows) till SQL Serve: 👉 2016 version but from SQL… Read More
Daily Tips for Oracle DBA
Dear Readers, In this article, we will see the following Daily Tips for Oracle DBA. Tip-1 : Date: 25-Nov-20 Provided By (Linkedin): Rakesh Monga If Database running slow then check below basic things: 👉 When this issue… Read More
GoldenGate 12c setup for Oracle Container Database
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 Setup in MySQL
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
Master Slave Configuration in Jenkins
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
UNDO segments not Releasing Space
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
Performance Investigation(Database / SQL)
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
MySQL Identifying unused indexes
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
Oracle Wait Events: DB scattered Read
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
