Partitioning in Oracle - Performance Basics 

List of all partitioning videos Part 1 : Partitioning in Oracle : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-m3q4lrE671Y.html Part 2 : Partitioning in Oracle - Performance Basics :ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-OQ8LXbxLI5g.html Part 3 : List Partitioning in Oracle : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-w6kB-90pFa4.html Part 4 : Range partitioning in Oracle : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-VBkpI4Ki49Q.html Part 5 : Hash Partitioning in Oracle : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-2YxOF_sJMLI.html Part 6 : Composite Partitioning in Oracle :ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-q_e9IkNtSWc.html Part 7 : Reference Partitioning in Oracle :ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-p8gNwr6Rtdo.html Part 8 : Local Vs Global Partitioned Index in Oracle 11g : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-t77fyUt8XPw.html Part 9 : Partitioning enhancement in 12 c :ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-o_WjapdXiQg.html

I knew a lot of this, but you helped fill in some of the blanks. The best bit is that you helped me be able to explain this, in simpler terms, to our non-DBA development team. Great job with this video! As someone who is learning a foreign language, I can appreciate how silly our (English) word pronounciation can be - and I appreciate when people help me pronounce my foreign language (German), when I get it wrong. When you say "contiguous" (meaning beside/connected), in the video, you pronounce it like "contagious" (easily transmitted, like a disease) Spelled similarly, they're actually pronounced completely differently (phoenetically: 4 syllable CON-TIG-YU-US vs 3 syllable CON-TA-JUS) My wife is not a native English speaker, so makes similar mistakes when she learns a word by reading. While I can only apologise, for how erratic the English language is, this is a word that, we DBAs, use a lot - and we, often, only learn mistakes in pronounciation when a native speaker can notice and point it out. This is not a criticism of your excellent video - genuinely just trying to help! Once again, fantastic video throughout!

Thank you so much for your great tutorials, Explaining in very friendly and deep manner, really love them.

Hi, This video is really very much informative and easy to understand.I agree that the video is lengthy but still I appreciate that each and every small part related to partition is covered with proper examples.its very rare that we get whole information related to a particular topic at one place. Thanks

Hello Sir, I have seen your videos for oracle partitioning and those are very informative and easy to understand the oracle data flow. please keep posting the videos on oracle performance tuning sections. A small request please upload the queries which you have been used during your explanation on video in the description. Thanks a lot.

very crisp and clear explanation.. Thanks a lot

Hi Vevek, It is really very nice and happy to watch your seriees of videos related to db stuff. Thank you for such a nice detailed videos with adequate explanation. Good Job.

Hello Vivek.. An excellent piece of demonstration.. This is the first time I am going through your videos on Partitioning in Oracle and at first ppt only I felt like giving you a full thumbs up for your effort. Excellent patience level and highly knowledgeable person demonstrating one of the vital most sections in Oracle architecture. I will definitely say about these lectures to all my friends.. Keep it up brother... :) Also, if you can share your mail id, so we can reach out to the expert for any clarification on Oracle and its features.. Waiting to hear from you more. Regards, Pritam

Thanks a lot. It clears all small doubts. Appreciated.

What do you mean by random IO operation and being sequential ? We have the ID's address in the index we can straight away fetch that record. And if we have another ID's we again perform one more read on the table on the basis of it's address. So as per my understanding we are reading blocks one by one ( or individual access to a table each time more precisely) instead of a multi block read in case of full table scan. Kindly clarify

what do you mean when you say a random I/O to find the actual row in the block? For a table with say 4000 blocks, how does it know which block it belongs to? If it doesn't know, then does it just randomly scans a block wishing that it would be lucky to have that row in that block? If so, then it would be just impossible to determine the time of a read operation, as the data could be on the very first block itself (if you are extremely lucky) or could be in last block (if you are extremely unlucky) and that way you would end up reading all the blocks! Something is surely missing in this explanation!

Execellent video😊 Thnks vivek wonderful presentation

superb bro !!! got to know some new things about DB blocks !

Hi Vivek, It's really a awesome video on partitioning. But can you please make a dedicated video on single Block I/O & Multiple Block I/O. Thanks in Advance.

Wonderful explanation.

Hi Bro, U r explanation is too good.. Thanks for uploading the videos on Partition

I have a question: how the root node selected by oracle for index creation if root node selection based on the median value then in case of live system data is continuously inserted into the table so each time there will be a change in the median value which means a change in root node value.

Hi , I have question ,when next extent is going to allocate ,and how system decides no. of blocks in extent and in case of same type of data means data belongs to single table or single partition

In the video at time 20:15,you say in order to fetch 25% data,we have already accessed 3000 blocks.I think you mean 3000 rows.Correct?

In case of the btree branch block how it find that which I'd we are looking for ... Like if we want to find id= 5555 ...and the value generated by rownum is not in branch block or child block

very well explained sir great tutorial indeed

brilliant

Hi Vivek, I have a table of size 20GB.I need to perform partition in that existing table,please give your valuable tips and suggestions.

Hello vivek, how can i go through all the videos you created. If you can help. Thanks in advanced

AWESOME VIDEO. WOW

Good Job

WOW....!!

Hi, Your videos are quite informative and it's good to learn from your videos. But it will be better if you make it rather short. Professionals don't have patience to watch lengthy videos. Why I'm saying because, if one couldn't understand in a single shot, he will go and watch again and again. If you will make it long no one will be interested for second time.

good explanation

Sir, Can you please answer these interview question which was asked to me. (1) How do we know that when we have to partition a table? (2) What will happen if we dont partition a table?

Very clear explanation.. keep making videos. I really appreciate your effor.. it would be a great if you give Notes in PDF..

Hi VIvek, Very good explanation. Keep up the good work.

Hi Vivek, what is need to give another name called which is a collection of blocks...I understand that block is the finest level of data storage and segment is the one which belongs to a table space which is used to store table or index...so what does an extent signify ?

Fantastic man.. :)

Excellent explanation! Keep it up bro!

It's very rare we will this kind of info in the youtube. Thanks so much.. It's really helpful for me..

Blocks, extents and segments Blocks is must fundamental unit Corresponds to specific number of bus (8kb on physical disk) Any object being created, must fundamental unit of storage is block (cells - our body analogy) Extent =specific number of contagious days blocks allocated for storing done specific type of information They are predefined in number Segment . Set of extents, each allocated for specific days structure, stored in same tablespace

Please create deep performance tuning video for PLSQL

Excellent... Wating for next...

Hi Vivek, at what basis the root node of the index is decided ?