Change remote trail location RMTTRAIL in pump in Goldengate

 Summary: This section explains the method to change REMOTE TRAIL location used in PUMP process in goldengate.

Description:

This blog is for modifying the remote trail RMTRAIL location in pump.

Case if to changing the mount point.

Location Before -/u02/app/oracle/product/19.0.0.0/gghome_1/dirdat/RPPPIA02/j2

Location After -/u03/app/oracle/product/19.0.0.0/gghome_1/dirdat/RPPPIA02/j2

Add new extract in Goldengate

Summary: Add new Extract process in GoldenGate

Description:

This blog is for adding a new extract in goldengate considering few assumptions.

1. GG manager is already configured.
2. DB level metadata, table/schema trandata is configured.
3. GG user is configured and had DBA access to datatabase

DB Growth report - Oracle

Database growth report - Average per day :

For capacity analysis and abnormalities of data load, it is mandatory to manage continuous review of the database utilization growth.

Monthly Database growth report - Average 

Oracle - Explain plan cost -- What is it and how optimizer calculated

Oracle - Explain plan cost -- What is it and how optimizer calculates it

In most of the Oracle DBA performance interviews and blogs, i observed one common question related to explain plan. 

Question is -- how do you define the cost mentioned in query explain plan? 

So here is the basic formula used by Oracle optimizer. 

For any SQL statement, oracle optimizer has to perform system I/O calls and CPUs to process the called blocks. Database information is stored in the logical form of ROWs and Columns of tables. Database storage unit is DB BLOCK (which is combination of OS Blocks based on the DB Block size) which stores the information. Each row of the table has ROW_ID, which is in hexadecimal format and donates the information about – Datafile, DB Block number & Row location in that DB block.

Now when oracle raises the request to read the number of blocks from disk, the system generates the calls for either single block read and/or multi-block-reads. This is called the IO cost.

Enable SSL Ambari server

This blogs shares the steps involved for enable SSL for Ambari-server using KeyStore and Private keys.

For more details click below ---

Install Apache hadoop V1 Pseudo mode on CentOS6.5

Purpose:

We have CentOS 6.5 on which we have to install Hadoop 1.2.1 with Java JDK-8.

Install Apace Ambari-Server on Linux Centos 6.5

Purpose: 
This blog explains the Ambari Server in Installation on CentOS.