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
psoftneto
Messages: 44
Registered: July 2008
Member
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 ?
Thanks
Previous Topic: Schema difference Script (merged 3)
Next Topic: db upgrade
Goto Forum:
  


Current Time: Fri Dec 09 23:11:03 CST 2016

Total time taken to generate the page: 0.08345 seconds