Let’s draw a table (any table). For simplicity I say: a block can only cater for 4 rows The table has 2 columns (ID and Text) Oracle assigns a rownumber within the block for every row If I would like to see all rows where ID=154, Oracle would have to look in all blocks, and …
Storage in a Oracle datafile: A table or an index is called a segment on the storage side of the Oracle database. Such een segment consists of extents. And these extents consists of blocks (the smallest unit of storage in a Oracle database). Most databases I see have a db_block_size of 8K (8192 bytes). If …
I think Hello World is most appropriate for a first post.