February DBA Tip of the Month

From: Cam White <info_at_revealnet.com>
Date: 1998/02/05
Message-ID: <01bd3241$88e7d640$1373b1cd@Preveal2>#1/1

From the DBA Pipeline - a free, internet-based community for Oracle DBAs hosted by author Mike Ault, and sponsored by RevealNet. Stop by and visit the DBA Pipeline for lively technical discussions, free white papers, tips and insights from Oracle DBAs around the world. http://www.revealnet.com/dbapipe/index.htm

February's Tip of the Month

Sizing database blocks

Oracle always reads in 64k chunks. It is best to size your database blocks and multi-block read count such that their product is 64k. Optimal results for full table scans have been reported with a 4k block size and a 16k multi_block_read_count equivilent setting.

Join the DBA Pipeline. It is completeley free, with no restricted areas. If you are (or plan to be) an Oracle DBA, this is a great place to keep your finger on the pulse of Oracle technology.

Best wishes,

Cam White
RevealNet, Inc. Received on Thu Feb 05 1998 - 00:00:00 CST