Hash Partitioning in Oracle

แชร์
ฝัง
  • เผยแพร่เมื่อ 4 ธ.ค. 2024

ความคิดเห็น • 33

  • @TechCoach
    @TechCoach  5 ปีที่แล้ว +1

    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

  • @susanmyers1
    @susanmyers1 ปีที่แล้ว +1

    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
      @TechCoach  ปีที่แล้ว

      I am glad I could help Susan :)

  • @navdeepgoyal4531
    @navdeepgoyal4531 ปีที่แล้ว

    Nice explainations on table partioning. thanks Vivek!!

  • @MARehmanDBA
    @MARehmanDBA หลายเดือนก่อน

    EXCELLENT WORK

  • @cblackattitude
    @cblackattitude 5 ปีที่แล้ว +6

    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
      @syedanoorumar1419 4 ปีที่แล้ว +1

      Exactly I have the same doubt

    • @wonkhong
      @wonkhong 4 ปีที่แล้ว

      @@syedanoorumar1419 Same for me...

  • @sandipjena
    @sandipjena 6 ปีที่แล้ว +1

    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
    @sumitchopra2075 6 ปีที่แล้ว +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 !!

    • @TechCoach
      @TechCoach  6 ปีที่แล้ว

      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

    • @sumitchopra2075
      @sumitchopra2075 6 ปีที่แล้ว

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

  • @vinzy147
    @vinzy147 6 ปีที่แล้ว

    Excellent explanation viviek.keep it up

    • @TechCoach
      @TechCoach  6 ปีที่แล้ว

      vinit naik Thanks Vinit :)

  • @vinaygadiraju217
    @vinaygadiraju217 5 ปีที่แล้ว

    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.

  • @andishez5359
    @andishez5359 4 ปีที่แล้ว

    Very Simple and Deep Thanks Again

    • @TechCoach
      @TechCoach  4 ปีที่แล้ว

      Thanks a lot :), your comments made my morning

    • @andishez5359
      @andishez5359 4 ปีที่แล้ว

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

  • @niharikajasti3661
    @niharikajasti3661 6 ปีที่แล้ว

    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 ?

  • @lakshmanl7489
    @lakshmanl7489 ปีที่แล้ว

    Why new videos are not coming from your side

  • @ariyamindra9720
    @ariyamindra9720 4 ปีที่แล้ว +1

    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
      @TechCoach  4 ปีที่แล้ว +1

      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 :)

  • @amitkumar-ju5cg
    @amitkumar-ju5cg 6 ปีที่แล้ว +1

    Good work!

  • @Saameeri
    @Saameeri 6 ปีที่แล้ว

    Awesome explanation

    • @TechCoach
      @TechCoach  6 ปีที่แล้ว

      Thanks for the kind words Saameeri.

  • @TheSomnath2000
    @TheSomnath2000 6 ปีที่แล้ว

    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
      @AnIndianAbroadd 6 ปีที่แล้ว

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

  • @argo1288
    @argo1288 4 ปีที่แล้ว

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

    • @TK-vt3ep
      @TK-vt3ep 3 ปีที่แล้ว

      Oracle will do that as u r partitioning on same keyd

  • @bhaskararao1548
    @bhaskararao1548 5 ปีที่แล้ว +2

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

  • @bhaskararao1548
    @bhaskararao1548 4 ปีที่แล้ว +3

    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
    @shrijeetshivdekar9076 4 ปีที่แล้ว

    Focus is on data distribution rather than grouping