首页 » ORACLE » AWR 之table scans (short tables)

AWR 之table scans (short tables)

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

打赏

对不起,这篇文章暂时关闭评论。