select a.obj#,a.table_scans_delta,b.object_name,b.owner,b.object_type 
from dba_hist_seg_stat a, dba_objects b
where a.obj# = b.object_id
and   b.owner like 'USERNAME%'
order by table_scans_total desc

Author Avatar

Josselin Joly

Scripts de vérification des produits soumis à licence Oracle
[script] Backup

Leave a Comment

Your email address will not be published. Required fields are marked *