• Oracle

    Oracle Database Physical and logical structures-04

    Database Physical and logical structures Block Smallest storage unit called a block. Size can be {2k,4k,8k,16k & 32k} – Default 8k. Standard block and Nonstandard block. Default is standard block. Db_block_size =8192. Once it’s configured we cannot change this. Each block has pctused, pctfree & high water mark. PCTused – For insert – 40% PCTfree – For Update – 10% High Water Mark – Separate the used & free space of block   Multiple block size (9i onwards) You can configure the size of the block for the database. Db_nk_cache_size = nk Db_16k_cache_size =16k Block utilization parameter: ================ Initran  1 Initial transaction Maxtran 256 – maximum transaction Pctused – inserted…