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
En poursuivant votre navigation sur ce site, vous acceptez l'utilisation de cookies. Ces derniers assurent le bon fonctionnement de nos services. En savoir plus.
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