Some things about tuning 9i
From stackpack report, the Buffer wait Statistics for DB section, and it include: data block, undo header, undo block and segment header . And from here , I want ask about the Automatic Undo Management (AUM), what is it ? And in 9.2.0.4, is it support AUM ?
And other question: There are some tables that alot of read physical. I know that, there are some methods to tuning this problem such as tune SQL, move tablespace or table to physical location , ... and there is a method is create tablespace with large BLOCKSIZE (now it is 8K) and if I create new tablespace with blocksize=16K and move this tables to it --> So when oracle read data from this tables, this change is effect ? And when create tablespace with BLOCKSIZE=16K, which parameters I need configure ?