Dear Readers, In this article, we will see the following Log Miner Configuration for Oracle Database. We can easily track history of activity on a database from archived redolog files using log miner. 1. ENABLE SUPPLEMENTAL LOGGING FOR THE DATABASE
|
1 |
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA; |
|
1 2 3 4 |
SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE; SUPPLEME -------- YES |
2. CHECK THE… Read More
Dear Readers, In this article, we will see the following Daily Tips for MongoDB. Tip-1 : Date: 30-Nov-20 Provided By: Srini Arra MongoDB is designed to meet the demands of modern apps: 👉 The document data model-presenting… Read More
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
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
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
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
