The use of Muliple block sizes provides DBAs with additional control over the UNIX disk i/0 subsystem. ORACLE's DBA should understand the fundamentals of some UNIX disk I/O.
Disk I/O is an important part of Oracle response time. reducing disk I/O will provide higher execution efficiency for tasks
Building a larger blocks will allow Oracle to access more row data in an I/O operation. Oracle9i supports muliple block sizes, oracle9i DBAs can easily move a table from a block size in a tablespace to another block size. As a result, I/O bottlenecks are reduced.
The Oracle9i DBA uses tools to easily reorganize the tables, using these tools to rearrange the table's row data in the same order as the primary index to reduce disk I/O operations based on index scans.
How do I reduce disk I/O operations in UNIX? There are three common technologies below to reduce disk I/O operations
Adjust SQL to minimize disk I/O operations.
You can usually use index scans instead of full table scans for large table operations.
Modifying the Oracle system Global Zone (SGA)
When you modify Shared_pool_size, Large_pool_size, db_cache_size the value of the parameter, disk I/O operations will be reduced, execution efficiency will improve.
Transforming tables to reduce disk I/O operations
You can use different block size to put the table selectively into the table space, the Operation table row data in the main index order.