Performance Tuning Tools We have discussed the tools that are being used for Performance Tuning in our previous article. Please find the article here Performance Tuning in Oracle – Part1 In this article we will be discussing the additional tools which are used in… Read More
Installation of MySQL Sever in Ubuntu using Generic Binaries. To begin the Installation process first download the generic binary from mysql.com or use the below link for downloading MySQL Sever Software Link to Download Binaries: https://dev.mysql.com/downloads/mysql/ Steps to Configure MySQL Server: Create a group with… Read More
Introduction of Performance Tuning: Performance tuning plays an important role in the DBA life. Performance tuning refers in the following areas: 1. Instance tuning 2. SQL tuning 3. Memory, Storage (I/O) 4. Network tuning 5. OS tuning For OS Tuning and Network tuning DBAs… Read More
Dear Readers, In this article we will see Similarities and Differences between the SQL and CQL languages. Every database must provide appropriate languages and interfaces to communicate with the database. Database Languages are used to create and maintain database. There are several databases like Oracle,… Read More
Dear Readers, In this article we will see Cassandra Data distribution and replication Part-2. Refer Cassandra Consistence hashing part-1 using below link. Cassandra : Cassandra Data distribution and replication In part-1 we have seen data distribution and replication. In part-2 you’re going to learn different… Read More
Dear Readers, In this article, we will see the following Datapump in Oracle 12c. Oracle Datapump was introduced in Oracle 10g. This article provides an overview of the main Data Pump enhancements in Oracle Database 12c Release 1. Oracle Datapump have two utilities They are 1.EXPDP… Read More
SQL*Loader in Oracle 12c SQL*Loader is a utility provided by the Oracle to load the data into Oracle databases from various files like ascii files,textfiles,external files and csv files etc.., SQL*Loader provides two methods for loading data: conventional path load direct path load CONVENTIONAL… Read More
Dear Readers, In this article, we will see the following Difference b/w Common user and Local user in Oracle 12c. Oracle has Introduced Multitenant architecture in the version 12c and also new terminologies for users in container database called LOCAL USER and COMMON USER. Common… Read More
How to perform DATAPUMP operations on standby database by converting SNAPSHOT standby. Data Guard is the name for Oracle’s standby database solution, used for disaster recovery and high availability. This article contains an updated version of 12cR1 Converting physical standby into snapshot standby and… Read More
Hello Readers I Standardized and customized the SecureCRT to group and link the frequently used commands. It will make the Oracle DBA job easy and fast. Download SecureCRT Software binaries using below link. https://www.vandyke.com/cgi-bin/account_login.php?pid=scrt_x64_870 Or Download SecureCRT binaries from Google Drive https://drive.google.com/file/d/1jfGtmKKwPwmOcjO1t5BJoN_b77V09a_q/view?usp=sharing Let me know… Read More
