|
-
===
c. I was reading in one of the Oracle site that, BUFFER
BUSY WAITS might occur due to access of the same rows in a
block/buffer by multiple processes and they are suggesting
to reduce NO of ROWS per block. HOW TO REDUCE # OF ROWS
PER BLOCK?
===
There are many ways to reduce buffer busy waits:
1 Increase PCTFREE
2 HASH Partition the table
3 If the table has many columns (say 100), then split into 2 tables - each one will have 50 columns.
4 If possible, redesign the application
Tamil
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|