Latest Answer : PCTFREE : This clause is used for future updation, If you increase PCTFREE value, There will be less rows inserted in block ...
Latest Answer : depends upon the storage parameters. ...
Data segment are the physical areas within a database block in which the data associated with tables and clusters are stored.
Due to insufficient Shared SQL pool size. Monitor the ratio of the reloads takes place while executing SQL statements. If the ratio
Database buffers are cache in the SGA used to hold the data blocks that are read from the data segments in the database such as tables, indexes and clusters DB_BLOCK_BUFFERS
Number of times processes repeatedly query the dictionary table is called recursive hints. It is due to the data dictionary cache is too small. By increasing the SHARED_POOL_SIZE
Changes made to entries are written to the on-line redo log files. So that they can be used in roll forward operations during database recoveries. Before writing them into
PCTFREE parameter Row size also reduces no of rows per block.
Each block contains entries as followsFixed block headerVariable block headerRow Header,row date (multiple rows may exists)PCTEREE (% of free space for row updation in future)
Latest Answer : A block is divided into1. Header2.free space3.data spaceThe free space is in the middle shrinks as header and data space grow.Space usage in the data space :The data space is managed with 2 parametersa.pctused b.pctfreesuppose pctused=40 ...
This is used to reserve certain amount of space in a block for expansion of rows.
