Space Management in Extents and Segments - DBArch Video 31 / DBPerf Video 13

In this video you will understand about the following
Dictionary managed Vs Locally Managed Tablespaces
Manual Vs Automatic Segment Space Management
PCTFREE and PCTUSED
Row Migration and Row Chaining .
Our Upcoming Online Course Schedule is available in the url below
docs.google.co...
Reach us at [e-mail]

[@RomanPeralta]

I enjoyed the great explanation you give for all these concepts Ramkumar. Thanks for sharing.

[@hrishiAOL]

Thank a lot for explaining in simple language. So helpful to understand concepts.

[@ernestledo341]

You make things look very simple. Thanks for the good work

[@BhavyaSinha-b6k]

You explain very nicely sir

[@govindpalariya3173]

Excellent tutorial🙏

[@vndvlogs5518]

Thank you so much sir

[@dipankarganguli]

Very nicely explained, thank you

[@elmokhliss4852]

Thanks

[@mobasherulhaque8121]

I don't understand one thing if oracle data blocks are multiple of os data blocks aren't you doing multiple I/O even when reading from single data block

[@navinestle]

Thank you Sir your prompt response.
The 3 video on PT, I have already watched out, expecting few more video on performance tuning(including AWR analysis with basic thumb rules.).

[@RamkumarSwaminathan]

+Naveen Singh yes they are coming

[@ashokm8348]

Thank you so much sir....

[@ranajparida3902]

Hello Ramkumar,
Thanks for explanation. Can you please help me to understand few doubts.
Aaj per the Database point of view, how a developer can identify a perticular query or piece of code is undergoing row MIGRATION or row CHAINING.
It is not possible, to check in Data dictionary table always for each query we run, if it is going through migration or chaining. Can you please let me know who can we get this sorted Permanently.
Regards,
Ranaj Parida.

[@syedamunawarfatima6989]

Sir, Do the blocks of the datafile are reserved on the disk when the datafile is created or they will grow as the object grows till it reaches the maximum size of the file? Please clear it...

[@RamkumarSwaminathan]

The Blocks for the datafile are created when the datafile is created. The number of blocks depends on the size. If you extend the datafile... then more blocks are added...

[@syedamunawarfatima6989]

@@RamkumarSwaminathan Thank u very much sir.....

[@navinestle]

Hello Sir nice video on extent management.
Could you please tell when you are planning to make video on RAC and performance tuning?

[@RamkumarSwaminathan]

+Naveen Singh thanks for the feedback, performance playlist is there Oracle Database Performance: ua-cam.com/play/PL3Hc8S1SG2AQBne3XvISEIn3x0NqUBND_.html

[@RamkumarSwaminathan]

+Naveen Singh will start RAC soon

[@mayureshshinde7059]

if we set pctfree=0 ,which means there is no space reserved for updates in a block. so , if we update the row of a block whose pctfree=0 , will the update work ?

[@RamkumarSwaminathan]

If the row needs more space for the update it will migrate to another block

[@RamkumarSwaminathan]

Watch the last section of the video ua-cam.com/video/s042ovOLxGw/v-deo.html

[@mdmanauveralam4148]

Hi sir,
It's very good video for DMT,LMT and PCTFREE, PCTUSE. but i try to open your website(www.tisyasolutions.com) but it is not showing.

[@RamkumarSwaminathan]

www.tisyasolutions.com

[@RamkumarSwaminathan]

Not sure why it's not working, please try again, I just checked....