With top wait event is DB file Sequential Read & Buffer busy waits I thought to increase the Freelists for index & tables.
All the tablespaces have Segment Space Managemnt as AUTO, Is it worth to increase the freelists with ASSM?? Please Advice.Quote:
Event Waits Time (s) % of Ela Time
------------------------------------ ------------ ----------- --------------
db file sequential read 32,866,091 347,809 84.26
CPU time 38,869 9.42
buffer busy waits 2,781,396 8,088 1.96
db file parallel write 114,175 6,266 1.52
db file scattered read 649,540 4,564 1.11
