| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
