 Related Questions 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 : Better performance, proper use of space . ... Latest Answer : to avoid row migration from future updates to the block pctfree is set. ... List the sequence of events when a large transaction that exceeds beyond its optimal value when an entry wraps and causes the rollback segment to expand into another extend. Latest Answer : by specifying the storage clause while creating table. ... Latest Answer : Calculate the total header size.Calulate the available data space per data block.Calulcate the combined column length by the avarge row.Calultate total average row size.Calculate avarge number of rows that can fit in data block.Calulate the number of ... Data segment are the physical areas within a database block in which the data associated with tables and clusters are stored. 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 List the Optional Flexible Architecture (OFA) of Oracle database? or How can we organize the tablespaces in Oracle database to have maximum performance ? SYSTEM - Data dictionary tables.DATA - Standard operational tables.DATA2- Static tables used for standard operationsINDEXES - Indexes for Standard operational tables.INDEXES1 - Indexes of static PCTFREE parameter Row size also reduces no of rows per block.
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
