select r.object_name, r.value as reads, o.value as freads, o.value/r.value as quality

from

( select owner, object_name, sum(value) as value

from gv$segment_statistics

where owner = ‘SAPCRM’

and statistic_name = ‘physical reads’

group by owner, object_name) r,

( select owner, object_name, sum(value) as value

from gv$segment_statistics

where owner = ‘SAPCRM’

and statistic_name = ‘optimized physical reads’

group by owner, object_name) o

where

r.owner = o.owner(+) and

r.object_name = o.object_name(+) and

r.value > 10000000

order by r.object_name;

e.g.
OBJECT_NAME                                   READS            FREADS     QUALITY      

ADR2                                          13,417,977         8,024,460        0.59     
ADRC                                          44,346,940       29,051,952        0.65     
BUT000                                       53,060,460       51,298,173        0.96     
BUT020                                       10,392,989       10,380,525        0.99     
COMD_EVHIST                              22,815,295           270,896        0.01     
COMM_PRODUCT                          15,434,447         2,575,635        0.16     
CRMM_BUAG                                10,588,323         6,598,218        0.62     
CRM_ICI_TRACES                          90,444,640             18,449            0     
IBIN                                            12,880,422         7,987,396        0.62     
LOYD_MSH_MEMS                     2,261,610,110         3,364,355            0      ***
LOYD_PT_TXN                              42,122,415       18,280,917        0.43     
SCAPPTSEG                                   12,080,171           279,222        0.02     
SMW3_BDOC2                               14,079,632         2,685,403        0.19     
SYS_LOB0000107104C00006$$        225,295,545     224,433,450        0.99     
VBDATA                                        12,818,971        2,622,517         0.2     
ZTC_LOY_MSH_BHV                        11,899,581      11,169,939        0.93     
ZTC_LOY_MSH_BHVD                    102,109,972      44,811,860        0.43     
ZTC_LOY_MSH_BHVDRE                  22,577,318        9,574,038        0.42     
ZTC_LOY_MSH_BHVD~0                 12,026,472       12,019,270        0.99     
ZTPRO_MI_EVENT                         15,444,970             37,786            0

Therefore queries accessing LOYD_MSH_MEMS or the table need modifying to improve query perfromance.
N.B. for full table scans data is not cached.