Home » RDBMS Server » Server Administration » How to read statspack results (Oracle 9i, AIX)
How to read statspack results [message #352583] Wed, 08 October 2008 08:09
Messages: 44
Registered: July 2008
Hi all,

I have one statspack report with the following "Top 5 Timed Events"

db file sequential read
db file scattered read
CPU time
buffer busy waits
log file sync

I think of the following:
=> increase db_file_multiblock_read_count
=> increase redo log or log buffer
=> keep some tables
=> I would like to increase block size

What should I check before keeping one table or before incresing db_block_size ?

buffer_pool_keep >= sum of all tables sizes ?
create a new tablespace with new block size and move data to the new tablespace with the new block size ?

Am I missing something ?
Previous Topic: A row of table is in which tablespace?
Next Topic: db upgrade
Goto Forum:

Current Time: Mon Aug 21 07:15:19 CDT 2017

Total time taken to generate the page: 0.01543 seconds