table fetch continued row 79,543 7.4 4.5
table scans (long tables) 58 0.0 0.0
table scans (short tables) 81,210 7.5 4.6
You have high small table full-table scans【table scans (short tables)】, at 7.5 per second. Verify that your KEEP pool is sized properly to cache frequently referenced tables and indexes. Moving frequently-referenced tables and indexes to SSD or the WriteAccelerator will significantly increase the speed of small-table full-table scans.
e.g
table scans (direct read) 0 0.00 0.00
table scans (long tables) 17 0.01 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 242,604 206.03 0.92
Segments by Table Scans
Total Table Scans: 1,475
Captured Segments account for 0.1% of Total
Owner Tablespace Name Object Name Subobject Name Obj. Type Table Scans %Total
DSMALL APP_INDEX PRIMARY_47 INDEX 1 0.07