About "Expert Oracle Database Architecture" Book


I'm reading the "Expert Oracle Database Architecture" book of Thomas Kyte, which is a must read for everyone who is serious on being an Oracle DBA.

Jonathan Lewis already said: "Frankly, if every DBA and developer in the world were made to work carefully through Tom Kyte’s book, I’d probably have to start offering consultancy services to SQL Server users because the number of clients needing Oracle consultancy would drop dramatically." in the foreword of the book. Still, i wanted to share some paragraphs from the "Data Files" part of the book. Following are taken out of only three pages of the book. I'm sharing this to show how the book is full of information and encourage you to immediately buy one and read.

Segments
==============================
You will find many CREATE statements that create multisegment objects. The confusion lies in the fact that a single CREATE statement may ultimately create objects that consist of zero, one, or more segments! For example, CREATE TABLE T ( x int primary key, y clob ) will create four segments: one for the TABLE T, one for the index that will be created in support of the primary key, and two for the CLOB (one segment for the CLOB is the LOB index and the other segment is the LOB data itself). On the other hand, CREATE TABLE T ( x int, y date ) cluster MY_CLUSTER will create zero segments (the cluster is the segment in this case).

Extents
==============================
Extents vary in size from one Oracle data block to 2GB. 11g Release 2 has introduced the concept of a “deferred” segment—a segment that will not immediately allocate an extent-, so in that release and going forward, a segment might defer allocating its initial extent until data is inserted into it.

Blocks
==============================
Here’s a little-known fact: the default block size for a database does not have to be a power of two. Powers of two are just a commonly used convention. You can, in fact, create a database with a 5KB, 7KB, or nKB block size, where n is between 2KB and 32KB.

Most blocks, regardless of their size, have the same general format, which looks something like:

 ------------------
|Header           | -> type of block (table block, index block, and so on), 
|                  |   transaction information when relevant regarding active and 
|                 |   past transactions on the block; and the address (location) 
|                 |   of the block on the disk.
|------------------|   The next two block components are found on the HEAP-                 |                  |   organized tables.      
|Table Directory   | -> The table directory, if present, contains information  
|                 |   about the tables that store rows in this block
|------------------|
|Row Directory     | -> The row directory contains information describing the 
|                 |   rows that are to be found on the block.
|------------------|
|                  | -> The remaining 2 pieces of the block are straightforward
|Free Space        |   there may be free space on a block, and
|                  |   then there will generally be used space that is 
|                  |   currently storing data.
|------------------|
|                  |
|Data              |
|                  |
|------------------|
|Tail              |
 ------------------


Exceptions to this format include LOB segment blocks and hybrid columnar compressed blocks in Exadata storage, for example, but the vast majority of blocks in your database will resemble the format in Figure

56 comments:

  1. It is very good blog.I am also looking for this from a long time.Many people like to visit here.I have seen many things over here.It is very good.

    Real Application Cluster

    ReplyDelete
  2. Thanks for sharing a information its really helpful for me to understand

    ReplyDelete
  3. i really appreciate knowledgeable post. thanks

    ReplyDelete
  4. valuable information..

    Hadoop training in hyderabad.All the basic and get the full knowledge of hadoop.
    hadoop training in hyderabad

    ReplyDelete


  5. Thanks For Sharing.It is very useful information

    Starpmo is one of the best institute to provide Online training courses in hyderabad. We have real time industry experts to provide Online classroom training


    pmp training in hyderabad


    pmp training

    Pmp Online Training In Hyderabad

    PMP Exams Hyderabad

    For more details Visit Us:Starpmo.com

    Contact Us:+91 7095608254

    ReplyDelete
  6. This comment has been removed by the author.

    ReplyDelete
  7. Thanks for sharing this informative blog. If anyone wants to get seo training in chennai | digital marketing training in chennai , Please visit DLK CDC located at Chennai.

    ReplyDelete
  8. This comment has been removed by the author.

    ReplyDelete
  9. Hey Really Thanks for sharing the best information regarding oracle,hope you will write more great blogs.

    Oracle Fusion SCM Online Training

    ReplyDelete
  10. I feel really happy to have seen your webpage and look forward to so many more entertaining times reading here. Thanks once more for all the details.

    Silver Light Training in Chennai | Java Spring Training in Chennai.

    ReplyDelete


  11. Nice blog..! I really loved reading through this article. Thanks for sharing such a amazing post with us and keep blogging...


    Best Data Science online training in Hyderabad

    Data Science training in Hyderabad

    Data Science online training in Hyderabad


    ReplyDelete
  12. You truly did more than visitors’ expectations. Thank you for rendering these helpful, trusted, edifying and also cool thoughts on the topic to Kate.
    fire and safety course in chennai

    ReplyDelete
  13. pmp training bangalore,Prepare for PMP Certification Exam and earn 35 Contact Hours. Master 10 Knowledge Areas and 47 Project Management Processes based on PMBOK Guide
    pmp training in bangalore

    ReplyDelete
  14. Thanks for posting this informative article thanks for sharing your great post,wish you have a nice day,happy every day.
    SQL Training in Chennai |
    SQL course in Chennai |
    SQL Classes in chennai


    ReplyDelete
  15. Such a nice blog, I really like what you write in this blog, I also have some relevant Information about Oracle Fusion Financials Online Training if you want more information.
    Oracle Fusion Financials Online Training

    ReplyDelete
  16. Thank you for sharing such a nice and really very helpful article
    Oracle Fusion HCM Online Training

    ReplyDelete
  17. Awesome post……. your article is really informative and helpful for me and other bloggers too

    Oracle Fusion SCM Online Training

    ReplyDelete
  18. It’s great to come across a blog every once in a while that isn’t the same out of date rehashed material. Fantastic read.Nice blog,I understood the topic very clearly,And want to study more like thisJava training in Chennai

    Java Online training in Chennai

    Java Course in Chennai

    Best JAVA Training Institutes in Chennai

    Java training in Bangalore

    Java training in Hyderabad

    Java Training in Coimbatore

    Java Training

    Java Online Training

    ReplyDelete
  19. Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.

    angular js training in chennai

    angular training in chennai

    angular js online training in chennai

    angular js training in bangalore

    angular js training in hyderabad

    angular js training in coimbatore

    angular js training

    angular js online training


    ReplyDelete
  20. Nice blog. thanks for sharing valuable information. oracle training in chennai

    ReplyDelete
  21. Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.




    AWS Course in Bangalore

    AWS Course in Hyderabad

    AWS Course in Coimbatore

    AWS Course

    AWS Certification Course

    AWS Certification Training

    AWS Online Training

    AWS Training

    ReplyDelete
  22. Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging.

    IELTS Coaching in chennai

    German Classes in Chennai

    GRE Coaching Classes in Chennai

    TOEFL Coaching in Chennai

    spoken english classes in chennai | Communication training


    ReplyDelete
  23. This Post is really supportive to all of us. Eager that these kind of information you post in future also. Thanks for Sharing Otherwise if anyone want To Learn SAS Training
    Database Developer Training in Bangalore

    ReplyDelete
  24. https://www.blogger.com/comment.g?blogID=1017035101234911849&postID=9038988133835583313&page=1&token=1615807665982&isPopup=true

    ReplyDelete
  25. Infycle Technologies, the
    No.1 software training institute in Chennai
    offers the leading Python course in Chennai for tech professionals and students at the best offers. In addition to the Python course, other in-demand courses such as Data Science, Selenium, Oracle, Java, Power BI, Digital Marketing also will be trained with 100% practical classes. After the completion of training, the trainees will be sent for placement interviews in the top MNC's. Call 7504633633 to get more info and a free demo.

    ReplyDelete
  26. Finish the Big Data Certification in Chennai from Infycle Technologies, the best software training institute in Chennai which is providing professional software courses such as Data Science, Artificial Intelligence, Java, Hadoop, Selenium, Android, and iOS Development, etc with 100% hands-on practical training. Dial 7502633633 to get more info and a free demo and to grab the certification for having a peak rise in your career. Get Big Data Certification in Chennai | Infycle Technologies

    ReplyDelete
  27. Thank you so much to share the valuable content with us. For more information visit this site Jegina Technologies is a best software training institute in coimbatore.

    ReplyDelete
  28. That's nice article blog post in this page. It's very important for me. You can click here for digital marketing agency delhi , seo services in delhi and Website Development company in Delhi

    ReplyDelete
  29. I liked this article very much. The content is very good. Keep posting.

    Best Full stack web development Online Training in Hyderabad

    ReplyDelete
  30. It is so nice blog. I was really satisfied by seeing this blog.

    pega testing online training
    pega testing course

    ReplyDelete
  31. Get the Oracle course in chennai from Infycle Technologies, one of the excellent Software Training Institute in Chennai. Great place to study Oracle and we also provide all technical courses like Oracle, Java, Data Science, Big data, AWS, Python, etc. with the best trainers receiving the amazing training for the best career. For more details and demo classes call 7504633633.

    ReplyDelete
  32. I appreciated your kind way of knowledge. I am happy to find such an informative post. Hope more to come. Are you searching for calling database Please visit India Mobile Database

    ReplyDelete