Hash Partitioning in Oracle

The Video explains Hash partitioning in oracle and how it focuses on equal data distribution.
It explains how hash partitioning uses partition joins to improve performance in VLDB by MPP.
#OraclePartitioning #Hashpartitioning #TechCoach

[@TechCoach]

List of all partitioning videos Part 1 : Partitioning in Oracle : kzbin.info/www/bejne/o2TUZZ-oeptqZ7s Part 2 : Partitioning in Oracle - Performance Basics :kzbin.info/www/bejne/hYKbfYuYrbF8a8k Part 3 : List Partitioning in Oracle : kzbin.info/www/bejne/rWfOc2BvZdV5l5Y Part 4 : Range partitioning in Oracle : kzbin.info/www/bejne/jHPOoXxqgM5nb7M Part 5 : Hash Partitioning in Oracle : kzbin.info/www/bejne/aIrbgHmVqK-Agqs Part 6 : Composite Partitioning in Oracle :kzbin.info/www/bejne/p5DIanyhg9mGjcU Part 7 : Reference Partitioning in Oracle :kzbin.info/www/bejne/pmnKf6qoa7enmtE Part 8 : Local Vs Global Partitioned Index in Oracle 11g : kzbin.info/www/bejne/qmial6yLqZ2Lhtk Part 9 : Partitioning enhancement in 12 c :kzbin.info/www/bejne/pZC6m5Smmb2ch8k

[@susanmyers1]

Thank You sir for the free training. New to GIANT tables and this helped a lot to determine which partition type to use/ Much appreciated.

[@TechCoach]

I am glad I could help Susan :)

[@navdeepgoyal4531]

Nice explainations on table partioning. thanks Vivek!!

[@cblackattitude]

In RAC we use common storage... the data is usually accessible equally from either nodes.. why do you say partition 1 resides on node 1 and partition 2 resides on node 2..?

[@syedanoorumar1419]

Exactly I have the same doubt

[@wonkhong]

@@syedanoorumar1419 Same for me...

[@sandipjena]

Hi Vivek, Now I'm almost clear on hash partitioning but can you please make a video on hash partitioning which elaborates in detailed manner. I mean, a real time example which shows how hash partitioning is beneficial whn created on different nodes and how creating dimensional tables in same nodes can reduces the data traffic resulting performance tuning. Thanks in advance. Waiting for your reply.

[@sumitchopra2075]

Awesome !! I was never clear on the partitioning concepts but your videos did the job for me really well. Thanks a lot for such a nice explanation with real world scenarios. :) I think I am going to watch all of your tutorials now .. Good luck !!

[@TechCoach]

Thanks a lot Sumit for the kind words.I am working on a new Initiative,a new youtube channel "An Indian Abroad". I would really appreciate if you help me by watching subscribing and sharing with your friends. kzbin.info/door/oLdaMxhfDgdgIAcRGlUvkg

[@sumitchopra2075]

Sure Man ! May I know where are you working currently ?

[@vinaygadiraju217]

I've some doubt's on table partitioning,We have a 5 tables with size of each is like approx 200GB of each, we did table partitioning using hash, as u said it will divided in to no.of partitions so that we can fetch data easy and also network traffic will be less. let us consider---------- I have partitioned a table xyz with 4 partitions using by hash my table got partitioned into 4 different tables. so after completion of partition can we see the table data manually whether the partitioning on table is working or not? If in case after partitioning we got a requirement to take table backup, So in this case how to take the back of already partitioned table backup? Kindly look into this case and provide if any solution available.

[@niharikajasti3661]

what should i do if the partition key is a string ?? in such cases list partition is advisable i guess... but what if i want to distribute data equally considering a string as a partition key ?

[@andishez5359]

Very Simple and Deep Thanks Again

[@TechCoach]

Thanks a lot :), your comments made my morning

[@andishez5359]

@@TechCoach You have a Great heart, God bless you and give you more power in your journey.

[@ariyamindra9720]

How many hash partition is required for any Large data set in a table; and what are the factors that should be taken care of while doing hash partitioning?

[@TechCoach]

It depends upon the amount of data and how many nodes you have, you want to apply hash partitioning on a column so that the data is uniformly distributed. I hope that helps :)

[@vinzy147]

Excellent explanation viviek.keep it up

[@TechCoach]

vinit naik Thanks Vinit :)

[@lakshmanl7489]

Why new videos are not coming from your side

[@amitkumar-ju5cg]

Good work!

[@TechCoach]

Thanks :)

[@TheSomnath2000]

Hi Vivek, Could you please suggests. We have an OLAP db where we have a non-partition table which is being accesses frequently resulting in high IOPS in the system . The size of the Nonpartitioned table is around 19 Gb . But the challenge here is it has a unique column which is not frequently used .So will hash partitioning the table be helpful . If so on which column we will make it hash . Any kind of help much appreciated . Thanks in advance .

[@AnIndianAbroadd]

Hey somnath, I was a little tied up last few days. Let me review your request tomorrow and answer it

[@argo1288]

How do you make sure your partitioning of these two tables will lie in the same node?

[@TK-vt3ep]

Oracle will do that as u r partitioning on same keyd

[@Saameeri]

Awesome explanation

[@TechCoach]

Thanks for the kind words Saameeri.

[@bhaskararao1548]

RAC concept explained is wrong , there is no node storage concept in rac , probably you are trying to explain 18C shrading ?

[@bhaskararao1548]

Your RAC concepts are not accurate. In RAC data is stored in a centralized environment like SAN/NAS etc with interconnect between node instances.

[@shrijeetshivdekar9076]

Focus is on data distribution rather than grouping