List of all partitioning videos Part 1 : Partitioning in Oracle : th-cam.com/video/m3q4lrE671Y/w-d-xo.html Part 2 : Partitioning in Oracle - Performance Basics :th-cam.com/video/OQ8LXbxLI5g/w-d-xo.html Part 3 : List Partitioning in Oracle : th-cam.com/video/w6kB-90pFa4/w-d-xo.html Part 4 : Range partitioning in Oracle : th-cam.com/video/VBkpI4Ki49Q/w-d-xo.html Part 5 : Hash Partitioning in Oracle : th-cam.com/video/2YxOF_sJMLI/w-d-xo.html Part 6 : Composite Partitioning in Oracle :th-cam.com/video/q_e9IkNtSWc/w-d-xo.html Part 7 : Reference Partitioning in Oracle :th-cam.com/video/p8gNwr6Rtdo/w-d-xo.html Part 8 : Local Vs Global Partitioned Index in Oracle 11g : th-cam.com/video/t77fyUt8XPw/w-d-xo.html Part 9 : Partitioning enhancement in 12 c :th-cam.com/video/o_WjapdXiQg/w-d-xo.html
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.
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..?
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 !!
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. th-cam.com/channels/oLdaMxhfDgdgIAcRGlUvkg.html
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.
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?
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 :)
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 ?
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 .
List of all partitioning videos
Part 1 : Partitioning in Oracle : th-cam.com/video/m3q4lrE671Y/w-d-xo.html
Part 2 : Partitioning in Oracle - Performance Basics :th-cam.com/video/OQ8LXbxLI5g/w-d-xo.html
Part 3 : List Partitioning in Oracle : th-cam.com/video/w6kB-90pFa4/w-d-xo.html
Part 4 : Range partitioning in Oracle : th-cam.com/video/VBkpI4Ki49Q/w-d-xo.html
Part 5 : Hash Partitioning in Oracle : th-cam.com/video/2YxOF_sJMLI/w-d-xo.html
Part 6 : Composite Partitioning in Oracle :th-cam.com/video/q_e9IkNtSWc/w-d-xo.html
Part 7 : Reference Partitioning in Oracle :th-cam.com/video/p8gNwr6Rtdo/w-d-xo.html
Part 8 : Local Vs Global Partitioned Index in Oracle 11g : th-cam.com/video/t77fyUt8XPw/w-d-xo.html
Part 9 : Partitioning enhancement in 12 c :th-cam.com/video/o_WjapdXiQg/w-d-xo.html
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.
I am glad I could help Susan :)
EXCELLENT WORK
Nice explainations on table partioning. thanks Vivek!!
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.
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..?
Exactly I have the same doubt
@@syedanoorumar1419 Same for me...
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 !!
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.
th-cam.com/channels/oLdaMxhfDgdgIAcRGlUvkg.html
Sure Man ! May I know where are you working currently ?
Very Simple and Deep Thanks Again
Thanks a lot :), your comments made my morning
@@TechCoach You have a Great heart, God bless you and give you more power in your journey.
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.
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?
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 :)
Excellent explanation viviek.keep it up
vinit naik Thanks Vinit :)
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 ?
Good work!
Thanks :)
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 .
Hey somnath, I was a little tied up last few days. Let me review your request tomorrow and answer it
Awesome explanation
Thanks for the kind words Saameeri.
RAC concept explained is wrong , there is no node storage concept in rac , probably you are trying to explain 18C shrading ?
How do you make sure your partitioning of these two tables will lie in the same node?
Oracle will do that as u r partitioning on same keyd
Your RAC concepts are not accurate. In RAC data is stored in a centralized environment like SAN/NAS etc with interconnect between node instances.
Why new videos are not coming from your side
Focus is on data distribution rather than grouping