How effectively we can use temporary tables in Oracle?

Hello guys, This is quite long back I am writing this post! In between there were…

How to analyze hadoop cluster?

This article is all about to find capacity of each component in a hadoop cluster. Hit…

How to setup Hadoop cluster using cloudera vm?

Cloudera released their version of hadoop for UI ,security and monitoring They also provide commercial support…

How to configure parameters in Hadoop cluster?

First we will go through list of configuration files and their properties. below are commands to…

What is federation in Hadoop?

Before explaining a federation concept we must know what are NameNodes, DataNodes and their functionality. HDFS…

What is Big Data? Why it become a hot topic in IT industry?

The term Big data refers to any kind of data that is in large volume or…

Common challenges while using bulk collect and techniques to to deal with it

Bulk collects are nothing but select statements that retrieve multiple rows from single fetch into declared…

What are best practices while using data warehouse recovery methodology?

In data warehouses backup and recovery can be very crucial task when you have 100’s of…

How to use SQL Access Advisor?

SQL Access Advisor suggests proper set of materialized views,partitioned tables,indexes for given workload. Complex tasks such…

What are outlines and how these are used?

Outlines categories are nothing but group of hints associated with a particular SQL statement. Oracle chooses…

Enable Notifications    Ok No thanks