Advantages of large block size:
1 Space wastage is very minimum.
2 Insert will be faster.
3 Fast Full table/index scan can be done in a less time.
Disadvantages of large block size:
1 Unwanted data/index will be cached in SGA.
|
Results 1 to 10 of 15
Thread: DB Block SizeThreaded View
|
Click Here to Expand Forum to Full Width |